oralce复习20190514

SELECT 'DROP '||table_name||' AS'||' CASCADE;'  as dropsql FROM  DBA_tables where owner=upper('scott')

--查询当前用户下的所有表

 select * from user_tables;