Posted By

thecrumb on 01/23/08


Tagged

sql Oracle


Versions (?)

Generate the SQL necessary to create sequences for every table (Oracle)


 / Published in: SQL
 

Generate the SQL necessary to create sequences for every table. NOTE: This doesn’t create sequences. The results need to be copied and run as a script.

  1. SELECT
  2. 'create sequence '
  3. || table_name
  4. || '_seq start with 1 nocache ;'
  5. FROM
  6. user_tables

Report this snippet  

You need to login to post a comment.