469,133 Members | 1,019 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

Generate SQL from SQL

Hi All,
I was trying to understand the question "Generate SQL from SQL". I am not exactly sure what that means. I Googled it but there wasn't an exact answer. Some say its DBMS_SQL, or Execute Immediate or some call a sql embedded inside a string. Kindly give an example.
Regards,
Aj
Apr 4 '09 #1
2 1649
debasisdas
8,127 Expert 4TB
the following sample just might help.

Expand|Select|Wrap|Line Numbers
  1. select TABLE_NAME, 'CREATE SEQUENCE SEQ_'||  LTRIM( table_name,'TBL') ||' MINVALUE 1 MAXVALUE 9999999999999999999999999 START WITH 1 INCREMENT BY 1 NOCACHE;' from user_tables
Apr 6 '09 #2
Thanks, for the sample code.
Regards,
Aj
Apr 7 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Garry Dawkins | last post: by
9 posts views Thread by Henk Verhoeven | last post: by
1 post views Thread by A Traveler | last post: by
reply views Thread by ward | last post: by
2 posts views Thread by bthubbard | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.