create table test100(
UserID number not null,
Name Varchar2(32),
Email Varchar2(32)
);
Create sequence sq1 start with 1 increment by 1;
insert into test100 values(sq1.currval,'mm','mmmm');
UserID number not null,
Name Varchar2(32),
Email Varchar2(32)
);
Create sequence sq1 start with 1 increment by 1;
insert into test100 values(sq1.currval,'mm','mmmm');
UserID number Primary key not null,
Name Varchar2(32),
Email Varchar2(32)
);
Create sequence sq1 start with 1 increment by 1;
SQL> select sq1.nextval from dual; NEXTVAL
----------
1
insert into test100 values(sq1.currval,'mm','mmmm');