1.通過user_tab_cols表查詢,條件是表名;查詢條件記得大寫
select?COLUMN_NAME,DATA_TYPE,DATA_LENGTH?from?user_tab_cols?where?table_name='QUESTION';
2.通過all_tab_columns表查詢,查詢條件記得大寫
????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';
????????完善條件減少結果條數?，*?可以像1中使用具體列名