File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes How to get Oracle Table Names Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How to get Oracle Table Names" Watch "How to get Oracle Table Names" New topic
Author

How to get Oracle Table Names

rajesh prakash
Greenhorn

Joined: Nov 02, 2003
Posts: 2
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
rajesh_chess@yahoo.com
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1135

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
Greenhorn

Joined: Nov 02, 2003
Posts: 2
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
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
I assume that this is not for a homework assignment. For Oracle, where "dbmd" is the DatabaseMetaData instance:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How to get Oracle Table Names