How to get Oracle Table Names

[rajesh prakash]

hi all,
I am new to java. Using ResultSetMetaData I can get Column Names
Likewise, I need to display Table Names from My Oracle Database.

Thanks in Advance
Prakash with Problems
[e-mail]

[Avi Abrami]

Rajesh,
If you want the list of table names, then you can use the DatabaseMetaData interface. However, if you are asking about the getTableName method in the "ResultSetMetaData" interface, then, as far as I know, it is not implemented (although I understand that that there is a "request for enhancement" regarding its implementation).
Good Luck,
Avi.

[rajesh prakash]

hi avi,
I found the method in api DatabaseMetaData and I dont know how to pass the parameters. If anybody knows the coding please help me.
Regards
Prakash

[Wayne L Johnson]

I assume that this is not for a homework assignment. For Oracle, where "dbmd" is the DatabaseMetaData instance:

// Get a list of all available tables (in every schema!)
String [] xxx = { "TABLE" };
ResultSet rs = dbmd.getTables(null, null, "%", xxx);
// loop through the list of table names and:
//   -- print out each table and a list of all columns
while (rs.next()) {
  rrss = dbmd.getColumns("%", "%", rs.getString("TABLE_NAME"), "%");
  System.out.println("Processing Table: " + rs.getString("TABLE_NAME"));
  // Print out each column with name, data-type, size, and nullable
  int    cSize;
  String cName, cType, cNull;
  while (rrss.next()) {
    cName = rrss.getString("COLUMN_NAME");
    cType = rrss.getString("TYPE_NAME");
    cSize = rrss.getInt   ("COLUMN_SIZE");
    cNull = rrss.getString("NULLABLE");
    System.out.println("      " + cName + '\t' + cType + '\t' + cSize + '\t' + cNull);
  }
  rrss.close();
}