SELECT T1.COLUMN_NAME, T1.DATA_TYPE, T1.DATA_LENGTH, T2.COMMENTSFROM USER_TAB_COLUMNS T1INNER JOIN USER_COL_COMMENTS T2 ON T1.TABLE_NAME||T1.COLUMN_NAME=T2.TABLE_NAME||T2.COLUMN_NAMEWHERE T1.TABLE_NAME = UPPER('TABLE_NAME')ORDER BY COLUMN_ID
?
SELECT T1.COLUMN_NAME, T1.DATA_TYPE, T1.DATA_LENGTH, T2.COMMENTSFROM USER_TAB_COLUMNS T1INNER JOIN USER_COL_COMMENTS T2 ON T1.TABLE_NAME||T1.COLUMN_NAME=T2.TABLE_NAME||T2.COLUMN_NAMEWHERE T1.TABLE_NAME = UPPER('TABLE_NAME')ORDER BY COLUMN_ID
?