ORACLE TABEL SCHEMA 받는 QUERY
SELECT C.TABLE_NAME AS TABLE_NAME , B.COMMENTS AS TABLE_DESC , C.COLUMN_ID AS COLUMN_ID , C.COLUMN_NAME AS COLUMN_NAME , SUBSTR(D.COMMENTS,1,120) AS COLUMN_DESC , E.PRIMARY_KEY AS PRIMARY_KEY , C.DATA_TYPE AS DATA_TYPE , CASE WHEN DATA_TYPE IN ('VARCHAR2','CHAR') THEN TO_CHAR(DATA_LENGTH) WHEN DATA_SCALE IS NULL OR DATA_SCALE = 0 THEN TO_CHAR(DATA_PRECISION) ELSE TO_CHAR(DATA_PRECISION) || ',' |..