Computer/DB

SQL index, sequnce

미처서 2014. 9. 1. 15:22

select a.index_name, a.table_name,  b.column_name, b.column_position 

from user_indexes a, user_ind_columns b

where a.index_name = b.index_name;



select * from employees

where email like 'SK%'


create index idx_fullname

   on employees (first_name, last_name)


select  first_name, last_name

from employees

where first_name like '%'

and last_name like '%'


select  first_name, last_name

from employees

where first_name like 'Ellen'

and last_name like 'Abel'




//시퀀스

create table board (

 no number primary key,

 title varchar2(20),

 contents varchar2(50) )


drop sequence board_seq

create sequence board_seq

 start with 1

 increment by 1


insert into board

values (board_seq.nextval, '알림', '월요일 반드시 출근')


select * from board


select board_seq.nextval from dual

select board_seq.currval from dual