select tc.COLUMN_NAME, tc.DATA_TYPE, tc.DATA_LENGTH, cc.COMMENTS from user_tab_cols tc, user_col_comments cc where tc.COLUMN_NAME=cc.COLUMN_NAME and tc.TABLE_NAME=upper('表名')
转载于:https://my.oschina.net/u/2375158/blog/507784
select tc.COLUMN_NAME, tc.DATA_TYPE, tc.DATA_LENGTH, cc.COMMENTS from user_tab_cols tc, user_col_comments cc where tc.COLUMN_NAME=cc.COLUMN_NAME and tc.TABLE_NAME=upper('表名')
转载于:https://my.oschina.net/u/2375158/blog/507784