aspose file tools*
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
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: 2495
    
    8

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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: what is command in Oracle for?