develog

USE_NLSELECT /*+ FULL(CU) ORDERED USE_NL(CU PY) */'FROM AAA CU, BBB PYWHERE CU.SEQ = PY.SEQ(+)

CREATE TABLE {TABLE_NM} NOLOGGINGCREATE INDEX {INDEX_NM} NOLOGGING

SELECT SYS_CONNECT_BY_PATH(CODE_NM, '/') PATH, A.* FROM TB_CODE A WHERE USE_YN = 1 START WITH CODE_SEQ = 1 CONNECT BY PRIOR CODE_SEQ = PARENT_CODE_SEQ ORDER SIBLINGS BY SORT_SEQ

ALTER TABLE MY_TABLE DISABLE ALL TRIGGERS;ALTER TABLE MY_TABLE ENABLE ALL TRIGGERS;

--휴지통 조회SELECT *FROM RECYCLEBIN; --휴지통 비우기PURGE RECYCLEBIN; --복구FLASHBACK TABLE 테이블명 TO BEFORE DROP;

SELECT *FROM USER_IND_EXPRESSIONS; SELECT *FROM USER_INDEXESWHERE 1=1AND INDEX_TYPE LIKE 'FUNCTION-BASED%';