--在PL/SQL中執(zhí)行,將以下語句中的“XNY300 ”改為你想查詢的數(shù)據(jù)庫的名稱,名稱必須大寫。
select b.TABLE_NAME as "表名",杭州博客網(wǎng)7XXpW&_1R,o*W
c.comments as "表說明",
7B#i2N[I)A3K*eCZ0 b.COLUMN_ID as "字段序號(hào)",杭州博客網(wǎng)7p`Z,L/p:~8dw
b.COLUMN_NAME as "字段名",
4r c-k"p.L5r)T0 b.DATA_TYPE as "字段數(shù)據(jù)類型",
6`(QM)U?{ _x0 b.DATA_LENGTH as "數(shù)據(jù)長度",
v:|0Fv4csgEV R0 b.DATA_PRECISION as "整數(shù)位",杭州博客網(wǎng)8j9lDh/@M3s],C
b.DATA_SCALE as "小數(shù)位",杭州博客網(wǎng) Se-c:fZ%t YL6bs$E
a.comments as "字段說明"
YH5f5nO0 from all_col_comments a, all_tab_columns b,all_tab_comments c
_;B5lvw*_ S*mc0 where a.owner = 'XNY300' and a.owner = b.OWNER and杭州博客網(wǎng)xYk8cr@taD
a.table_name = b.TABLE_NAME and a.column_name = b.COLUMN_NAME and杭州博客網(wǎng) Q7?[D,sz c
c.table_name = a.table_name and c.owner = a.owner杭州博客網(wǎng)@}KtL#s_x7Z0lf
order by a.table_name, b.COLUMN_ID
聯(lián)系客服