컬럼정보조회

SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME LIKE 'TB_USER_INFO%' AND OWNER = 'SCOTT' SELECT T.TABLE_NAME AS TBL_NM , T.COLUMN_NAME AS COLS_ID , C.COMMENTS AS COLS_NM , C.COMMENTS AS NOTE , CASE WHEN T.DATA_TYPE='TIMESTAMP(6)' THEN 'TIMESTAMP' ELSE T.DATA_TYPE END AS DATA_TP_NM , CASE WHEN T.DATA_TYPE='VARCHAR' THEN T.DATA_LENGTH WHEN T.DATA_TYPE='NUMBER' THEN T.DATA_PRECISION END AS DATA_..

원문링크 : 컬럼정보조회