摘要:create sequence on hr database
--step 1
--create table dept(id number(7) constraint department_id_pk primary key,
--name varchar2(23));
--step 2
--create sequence dept_id_seq
--start with 100
--increment by 10
--maxvalue 10000;
--step 3:test
--insert into dept
--values(dept_id_seq.nextval,'rickey');
--find sequences
select * from user_sequences;