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