表字段信息

2019独角兽企业重金招聘Python工程师标准>>>

select tb1.代码,tb1.数据类型,tb2.comments "注释" from (select t.COLUMN_NAME "代码",t.DATA_TYPE||'('||t.DATA_LENGTH||')' "数据类型"  from all_tab_columns  t where table_name='T_SERVICE_064_SELBROKER') tb1 join (SELECT * FROM USER_COL_COMMENTS t WHERE TABLE_NAME= 'T_SERVICE_064_SELBROKER') tb2 on tb1.代码=tb2.COLUMN_NAME;

转载于:https://my.oschina.net/u/727394/blog/155340