Oracle DDL


         define schema='schema_name'
         

         create sequence &schema..seqname
         

          increment by 1
         

          start with 1
         

          nocache;
         

         grant select
         

          on &schema..seqname
         

          to rolename1,
         

          rolename2;

Next: Create Table

Home > Computers > Databases > Oracle > DDL > Create Sequence

Viewing mobile website page. Switch to WML or Full HTML