SQL index, sequnce

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