oracle 失去表的字段和备注
oracle 得到表的字段和备注
--oracle 得到表的字段和备注
select lower(column_name),data_type,data_length,
(select t_s.comments from all_col_comments t_s where t_s.column_name=t.column_name and t_s.table_name='T_ZHZF_WS_DCXW_TZS' and t_s.owner='TEST') comments
from all_tab_columns t where
table_name =upper('T_ZHZF_WS_DCXW_TZS' )
and owner='TEST'
order by column_id
;