l18qyw
Last Updated: February 25, 2016
·
341
· mitemitreski
Bef42dba7a0eed128fd73fc13c9a59fe

Generate drop table command for user schema PL/SQL

The following will generate a drop table for each of the user tables:

select 'drop table '||table_name||' cascade constraints;' from user_tables;
Say Thanks
Respond