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 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