aspose file tools
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 2533
    
  10

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?