select a.COLUMN_NAME ||'(' || a.data_type ||')'as data_type,

創(chuàng)新互聯(lián)建站主營梁河網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,重慶APP開發(fā),梁河h5小程序定制開發(fā)搭建,梁河網(wǎng)站營銷推廣歡迎梁河等地區(qū)企業(yè)咨詢

       t.comments||'(' || a.COLUMN_NAME ||')'as filed

 from user_col_comments t,user_tab_columns a

 where t.table_name = upper('owt_blocdel')

  and t.table_name =a.TABLE_NAME

  and t.column_name =a.COLUMN_NAME

 orderby column_id