Oracle - Drop all table in account(오라클 자기 계정 테이블 전체 삭제)

DEVELOPMENT 2009/12/09 15:46 
SQL> Begin                                                    
   for c in (select table_name from user_tables) loop
  execute immediate ('drop table '||c.table_name||' cascade constraints');
  end loop;
  End;
  .
SQL> run
SQL> PURGE RECYCLEBIN;





크리에이티브 커먼즈 라이센스
Creative Commons License
2009/12/09 15:46 2009/12/09 15:46
NO TRACKBACK AND NO COMMENT
http://www.javapattern.info/trackback/313