首頁(yè) 猿問(wèn) oracle怎么通過(guò)sql查看表的結(jié)構(gòu)

oracle怎么通過(guò)sql查看表的結(jié)構(gòu)

Oracle

MM們 2018-10-07 04:04:39

查看完整描述

1 回答

慕妹5005176

TA貢獻(xiàn)3條經(jīng)驗(yàn) 獲得超0個(gè)贊

1.通過(guò)user_tab_cols表查詢(xún),條件是表名;查詢(xún)條件記得大寫(xiě)
select?COLUMN_NAME,DATA_TYPE,DATA_LENGTH?from?user_tab_cols?where?table_name='QUESTION';
2.通過(guò)all_tab_columns表查詢(xún),查詢(xún)條件記得大寫(xiě)
????2.1?
????select?COLUMN_NAME?from?all_tab_columns?where?owner='ZJQ'?and?table_name='QUESTIONS';
????????先獲取表中的列
????2.2
????select?*?from?all_tab_columns?where?owner='ZJQ'?and?table_name='QUESTIONS'?AND?column_name='QUE_ID';
????????完善條件減少結(jié)果條數(shù)?，*?可以像1中使用具體列名

反對(duì) 回復(fù) 2018-11-21