pl怎么管理oracle账号oracle得到表的字段和备注

oracle得到表的字段和备注

–oracle 得到表的字段和备注

  www.2cto.com  

select lower(column_name),data_typoracle账号e,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;