Help for this page

Select Code to Download


  1. or download this
    create sequence seq_name 
       start with 1
    ...
       nocycle
       cache 20;
    
  2. or download this
    INSERT INTO table_name 
      ( id_no, col1, col2 )
    values 
      ( seq_name.NEXTVAL, '$col1', '$col2' )