본문 바로가기

프로그래밍관련/DBMS

[Oracle] 테이블 목록, select table name


SELECT
 'DELETE FROM ' || OBJECT_NAME || ';' AS DELETE_QUERY
FROM
 USER_OBJECTS
WHERE
 OBJECT_TYPE = 'TABLE'
ORDER BY OBJECT_NAME