t.data_type ,
c.COMMENTS
FROM user_tab_columns t, user_col_comments c
WHERE t.table_name = c.table_name
AND t.column_name = c.column_name
AND t.table_name = 'HDSA0001'));
另外:SELECT t.table_name ,
t.column_name ,
t.data_type ,
c.COMMENTS
FROM user_tab_columns t, user_col_comments c
WHERE t.table_name = c.table_name
AND t.column_name = c.column_name
AND t.table_name = 'HDSA0001' 本身是没有问题的。可以查出来数据