Web Recipes

DELETE FROM 테이블 ;  --데이터 삭제후 오라클 로그에 쌓인다 TRUNCATE TABLE 테이블 ; --데이터를 완전 삭제한다(복구 불가)

SELECT A.COLUMN_ID, A.COLUMN_NAME, A.DATA_TYPE, A.DATA_LENGTH, A.NULLABLE, B.COMMENTS FROM  ALL_TAB_COLUMNS A, ALL_COL_COMMENTS B WHERE A.TABLE_NAME = B.TABLE_NAME AND  A.COLUMN_NAME = B.COLUMN_NAME AND  A.TABLE_NAME =  테이블 이름 ORDER   BY  A.TABLE_NAME, A.COLUMN_ID ;

SELECT A.TABLE_NAME, B.COMMENTS FROM  ALL_TABLES A, ALL_TAB_COMMENTS B WHERE   A.TABLE_NAME = B.TABLE_NAME ORDER   BY  A.TABLE_NAME ;

SELECT     C.OWNER,     C.TABLE_NAME,     C.CONSTRAINT_NAME,     CC.COLUMN_NAME,     R.TABLE_NAME AS TN,     RC.COLUMN_NAME AS CN,     CC. POSITION FROM         DBA_CONSTRAINTS C,      DBA_CONSTRAINTS R,      DBA_CONS_COLUMNS CC,      DBA_CONS_COLUMNS RC WHERE             C.CONSTRAINT_TYPE = 'R' AND     C.OWNER = '사용자' --AND     C.TABLE_NAME = '테이블' --해당 태이블의 FK 검색 --AND     R.TABLE_NAME = '테이블' --해당 테이블의 PK가 엮인거 검색 AND     C.R_OWNER = R.OWNER AND     C.R_CONSTRAINT_NAME = R.CONSTRAINT_NAME AND     C.CONSTRAINT_NAME = CC.CONSTRAINT_NAME AND     C.OWNER = CC.OWNER AND     R.CONSTRAINT_NAME = RC.CONSTRAINT_NAME AND     R.OWNER = RC.OWNER AND     CC. POSITION = R...