oracle 查詢表字段明細、字段注釋、表註釋 收藏 查詢表字段明細select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE from all_tab_columns where table_name='tablename'字段注釋select * from user_col_comments;表注釋select * from user_tab_comments; 表明細+表注釋+字段明細+字段注釋select ATC.OWNER,atC.TABLE_NAME,utc.comments,ATC.COLUMN_NAME,ATC.DATA_TYPE,ATC.DATA_LENGTH,ATC.NULLABLE, ucc.comments from (select ATC.OWNER,atC.TABLE_NAME,ATC.COLUMN_NAME,ATC.DATA_TYPE,ATC.DATA_LENGTH,ATC.NULLABLE from all_tab_columns ATC where ATC.owner in (用戶名1,用戶名2........) ) atcleft outer join user_col_comments ucc on atc.table_name=ucc.table_name and atc.column_name=ucc.column_nameleft outer join user_tab_comments utc on atc.table_name=utc.table_nameorder by atc.table_name,atc.column_name本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/vesanchen/archive/2009/04/03/4045893.aspx
通过它自己很难确知。 可以查询数据字典,获取信息 select * from user_tab_columns where table_name='yout_table_name';
查詢表字段明細select column_name,data_type,data_length,DATA_PRECISION ,DATA_SCALE
from all_tab_columns where table_name='tablename'字段注釋select * from user_col_comments;表注釋select * from user_tab_comments; 表明細+表注釋+字段明細+字段注釋select ATC.OWNER,atC.TABLE_NAME,utc.comments,ATC.COLUMN_NAME,ATC.DATA_TYPE,ATC.DATA_LENGTH,ATC.NULLABLE, ucc.comments from (select ATC.OWNER,atC.TABLE_NAME,ATC.COLUMN_NAME,ATC.DATA_TYPE,ATC.DATA_LENGTH,ATC.NULLABLE
from all_tab_columns ATC where ATC.owner in (用戶名1,用戶名2........) ) atcleft outer join user_col_comments ucc on atc.table_name=ucc.table_name and atc.column_name=ucc.column_nameleft outer join user_tab_comments utc on atc.table_name=utc.table_nameorder by atc.table_name,atc.column_name本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/vesanchen/archive/2009/04/03/4045893.aspx
可以查询数据字典,获取信息
select * from user_tab_columns
where table_name='yout_table_name';
以及其他你所需要的信息,至于该表字段数目,则需要count出来了。
这样就能查出 表T_IB_CALLRECORD里面的字段了。
select t.column_name from (select * from user_col_comments) t where t.table_name='tableName';
这样就能查出 表T_IB_CALLRECORD里面的字段了。
http://baike.baidu.com/view/303610.htm?fr=ala0_1
String sql="select * from "+tableName;
System.out.println("sql:"+sql);
ResultSet rs = st.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
list=new ArrayList<String>();
for(int i=1;i<=rsmd.getColumnCount();i++){
list.add(rsmd.getColumnName(i));
}