Oracle获取表结构sql

--无条件筛选查询所有表结构
SELECT t.table_name,
 t.colUMN_NAME,
 t.DATA_TYPE || '(' || t.DATA_LENGTH || ')',
 t1.COMMENTS
 FROM User_Tab_Cols t, User_Col_Comments t1
WHERE t.table_name = t1.table_name
AND t.column_name = t1.column_name) 






--把查询的所有表结构当做条件进行筛选
select * from (

SELECT t.table_name,
 t.colUMN_NAME,
 t.DATA_TYPE || '(' || t.DATA_LENGTH || ')',
 t1.COMMENTS
 FROM User_Tab_Cols t, User_Col_Comments t1
WHERE t.table_name = t1.table_name
AND t.column_name = t1.column_name) a where a.table_name in(

'T_QUESTION',
'T_QUESTION_2017_12_13'


);