17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT T1.Column_Id,
T2.COMMENTS,
T1.COLUMN_NAME,
T1.DATA_TYPE || '(' || T1.DATA_LENGTH || ')' ,
T1.DATA_LENGTH
FROM USER_TAB_COLS T1, USER_COL_COMMENTS T2
WHERE T1.TABLE_NAME = T2.TABLE_NAME
AND T1.COLUMN_NAME = T2.COLUMN_NAME
AND T1.TABLE_NAME = '表名' --要大写
order by Column_Id asc;