Generate SQL from SQL

[eeriehunk]

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

[debasisdas]

the following sample just might help.

select TABLE_NAME, 'CREATE SEQUENCE SEQ_'||  LTRIM( table_name,'TBL') ||' MINVALUE 1 MAXVALUE 9999999999999999999999999 START WITH 1 INCREMENT BY 1 NOCACHE;' from user_tables

[eeriehunk]

Thanks, for the sample code.
Regards,
Aj