[ORACLE] View Oracle Table and Column information
--COLUMN INFORMATION FOR TABLE SELECT TABLE_NAME , COLUMN_NAME , DATA_TYPE , DATA_LENGTH , DATA_PRESICION , DATA_SCALE , NULLABLE , COLUMN_ID , DATA_DEFAULT , CHAR_LENGTHFROM USER_TAB_COLUMNSWHERE TABLE_NAME = 'TABLE_NAME' --FIELD COMENT SELECT COLUMN_NAME , COMMENTSFROM USER_COL_COMMENTSWHERE TABLE_NAME='TABLE_NAME' --COLUMN INFORMATION FOR TABLE SELECT A.COLUMN_ID , B.COMMENTS , A.COLUMN_NAME ..
2016. 11. 30.