Help for this page

Select Code to Download


  1. or download this
    create sequence seq_name
   start with 1
...
   cache 20;
create public synonym seq_name for owner.seq_name;
grant select on seq_name to joe_user;
  2. or download this
    insert into table 
    (seq_col, cola, colb, colc)
  values 
    (seq_name.NEXTVAL, 'data','moredata','otherdata')
  3. or download this
    insert into table 
  values 
    (seq_name.NEXTVAL, 'data','moredata','otherdata')