[code]SELECT a.COLUMN_NAME,a.DATA_TYPE,a.DATA_LENGTH,a.NULLABLE,b.COMMENTSfrom ALL_TAB_COLUMNS a,ALL_COL_COMMENTS bWHERE a.OWNER=b.OWNER AND a.TABLE_NAME=b.TABLE_NAME AND a.COLUMN_NAME=b.COLUMN_NAMEAND a.OWNER=\'LOANCORE\' AND a.TABLE_NAME=\'T_BA_REPAY_PLAN\'ORDER BY a.COLUMN_ID;