select table_name from all_tab_comments where owner='SYSTEM(just a example)'
Class.forName("oracle.jdbc.driver.OracleDriver"); c = DriverManager.getConnection(dbUrl,user,password); String query = "Select * from " + oracleTableName; s = c.createStatement(); r = s.executeQuery(query); rm = r.getMetaData(); int tableColumnNumber = rm.getColumnCount(); oracleTableColumnNames = new String[tableColumnNumber]; for (int i = 0; i < tableColumnNumber; i++) oracleTableColumnNames[i] = rm.getColumnName(i+1);
楼上说的对,这都是不同数据库特供的, 不属于标准SQL
oracle select table_name, constraint_name, from user_constraints where table_name='表名'
搜索
Hypersonic
c = DriverManager.getConnection(dbUrl,user,password);
String query = "Select * from " + oracleTableName;
s = c.createStatement(); r = s.executeQuery(query);
rm = r.getMetaData();
int tableColumnNumber = rm.getColumnCount();
oracleTableColumnNames = new String[tableColumnNumber];
for (int i = 0; i < tableColumnNumber; i++)
oracleTableColumnNames[i] = rm.getColumnName(i+1);
不属于标准SQL
select table_name, constraint_name, from user_constraints where table_name='表名'