Advanced Search

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

/ Published in: SQL
Save to your folder(s)
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

Copy this code and paste it in your HTML 
  1. SELECT 
  2.     'create sequence ' 
  3.     || TABLE_NAME 
  4.     || '_seq start with 1 nocache ;'  
  5. FROM 
  6.     user_tables

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.