This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes what is command in Oracle for? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is command in Oracle for?" Watch "what is command in Oracle for?" New topic
Author

what is command in Oracle for?

Arun Maalik
Ranch Hand

Joined: Oct 25, 2005
Posts: 216
Hey Ranchar what is command in oracle to see the list of database and to see the list of table in a database.

Regard

Arun
Anupam Bhatt
Ranch Hand

Joined: Mar 12, 2004
Posts: 81
Originally posted by Arun Maalik:
Hey Ranchar what is command in oracle to see the list of database and to see the list of table in a database.

Regard

Arun


you could google for a quick answer ;)
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2476
    
    7

Originally posted by Arun Maalik:
Hey Ranchar what is command in oracle to see the list of database and to see the list of table in a database.

Regard

Arun


select * from all_tables;

column owner returns the database schema,
column table_name returns the table name.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what is command in Oracle for?
 
Similar Threads
using Cloudscape
running sql script file from java
autogenerated keys
does the Oracle JDBC driver auto-commit?
what is the command to see table in oracle