Your Ad Here

advanced code snippet search

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.

Expand | Embed | Plain Text 
  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.