테이블 삭제 Begin for c in (select table_name from user_tables) loop execute immediate 'drop table '||c.table_name||' cascade constraints'; end loop; End; 시퀀스 삭제 Begin for c in (SELECT * FROM all_sequences WHERE SEQUENCE_OWNER='DBUSER') loop execute immediate 'drop SEQUENCE '||c.sequence_name; end loop; End;

declare ret VARCHAR2(30); BEGIN GET_DOCUMENT_CD_P(ret, 'TBL_MEMO'); dbms_output.put_line('ret = ' || ret); END;