oracle查询表关联字段名,ORACLE查询表的字段名几种方式

1、oracle查询表的字段名并连接成用逗号隔开的字符串  select max(substr(SYS_CONNECT_BY_PATH(COLUMN_NAME, ','),2)) col from (  select 'a.'||COLUMN_NAME as COLUMN_NAME,column_id from sys.user_tab_columns  where table_name='ENTBT_ENT_INFO_OUT')  start with column_id=1  connect by column_id=rownum;  2、oracle查询表的字段名  select 'private String  '||T.COLUMN_NAME||'= null ;     //'||T.COMMENTS from sys.all_col_comments t  where t.owner ='CIQAGENT' AND T.TABLE_NAME ='T_ENT_MONEY'  3、oracle查询表的字段名并转成小写  select ­ 'BuildBtEntUsrInfoSbf.append(""+'  || 'BtEntUsrinfo[i]+' || '"'||Lower(REPLACE(T.COLUMN_NAME,'_',''))|| '>");'  from sys.all_col_comments t  where t.owner ='DVNEWS' AND T.TABLE_NAME ='ORGBT_ENT_USR_IN'  select 'BuildCtCerInfoSbf.append(""+' || 'CtCerInfo['||to_number(T.COLUMN_ID-1)||']+' || '"'||T.COLUMN_NAME|| '>");' from sys.user_tab_columns t where T.TABLE_NAME ='CT_CER' select column_id,'digester.addCallMethod("message/ctsf/'||Lower(replace(T.COLUMN_NAME,'_',''))||'","set'||T.COLUMN_NAME||'",0 );'    from sys.user_tab_columns t ­ where t.table_name = 'CT_SF' order by t.COLUMN_ID ­ select ­        replace('OutEntInfoSbf.append(OutEntInfo.get' || T.COLUMN_NAME || '());'||         chr(13)||'OutEntInfoSbf.append(",");','""','') ­   from sys.user_tab_columns t  where t.table_name = 'BT_ENT_INFO'  order by t.COLUMN_ID select         'if(!Utility.chgnulltospace(OutEntInfo.get' || T.COLUMN_NAME || '()).equals(""))'       ||chr(13)||'{'       ||chr(13)||'OutEntInfoSbf.append("'||T.COLUMN_NAME||'=");'       ||chr(13)||'OutEntInfoSbf.append("''");'       ||chr(13)||'OutEntInfoSbf.append(Utility.chgnulltospace(OutEntInfo.get' || T.COLUMN_NAME || '()));'       ||chr(13)||'OutEntInfoSbf.append("''");'       ||chr(13)||'OutEntInfoSbf.append(",");'       ||chr(13)||'}'   from sys.user_tab_columns t where t.table_name = 'CT_SF' order by t.COLUMN_ID  select '//' || t.COMMENTS || chr(13) || 'private String  ' || b.COLUMN_NAME ||        '= null ;'   from sys.all_col_comments t, user_tab_columns b  where t.table_name= b.TABLE_NAME and t.column_name=b.COLUMN_NAME    and t.owner = 'DVCOMM'    AND T.TABLE_NAME = 'DVINSP_ORI_INV_INFO'  order by b.COLUMN_ID select 'PerInfo.set'||T.COLUMN_NAME || '(Utility.chgnull(rest.getString("'||T.COLUMN_NAME||'")))'||';' from sys.user_tab_columns t where T.TABLE_NAME ='S_PER_INFO' order by t.COLUMN_ID select 'sbf.append(""+' || 'Utility.chgnull(PerInfo.get'||T.COLUMN_NAME||'())+' || '"'||T.COLUMN_NAME|| '>");' from sys.user_tab_columns t where T.TABLE_NAME ='S_PER_INFO' order by t.COLUMN_ID