Sequence With Insert Command
5BCA Oracle
create sequence sq_demo4 start with 1
create sequence sq_demo5 start with 1 maxvalue 10
SELECT sq_demo1.CURRVAL FROM dual;
insert into st values(sq_demo3.nextval,'umesh')
create sequence sq_reg start with 7293001
insert into st values(sq_reg.nextval,'Umesh')
select * from st order by sid