oracle查询表的结构

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

原文地址:https://www.cnblogs.com/smile502/p/11288102.html