Under what circumstances ( example please ) SQL generating SQL is needed ?
When you want to create some script dynamically. Say for example you want to to see the description of tables under a perticular user schema Code: spool alter_table.sql SELECT "desc "||table_name ||" " FROM user_tables; spool off; @alter_table.sql Sam
spool alter_table.sql SELECT "desc "||table_name ||" " FROM user_tables; spool off; @alter_table.sql
Thanx Sam Life is a journey, not a destination!
Forum Rules