fetching oracle table names into java program

[srinivas k]

Hi all,
Could any one pl: let me know as to how we could fetch the table names from oracle database for a perticular user, a code snippet regarding this is very much appreciated
Thanks

[Lasse Koskela]

Try this. I don't know whether your database will display all tables or just those which are visible to the active user.

java.sql.Connection c = ...; // get this somewhere
java.sql.DatabaseMetaData dbMetaData = c.getMetaData();
java.sql.ResultSet rs = dbMetaData.getTables(null, null, null, null);
while (rs.next()) {
    System.out.println(rs.getString("TABLE_NAME") + " (" + rs.getString("TABLE_TYPE") + ")");
}

[ August 19, 2003: Message edited by: Lasse Koskela ]

[Pradeep bhatt]

Why not just use the query
select table_name from all_tables where owner='SCOTT';

You can replace the owner by appropriate user name.

[Lasse Koskela]

True. That would work if you're not afraid of being slightly locked into Oracle-speficic SQL and if the user has the grant to do a SELECT on ALL_TABLES.

[Pradeep bhatt]

You can use use user_tables in place of all_tables.
Yes, it is Oracle specific.