basic browsing commands for oracle...

From: Nathan Affleck <n8_at_phatmorton.com>
Date: Fri, 08 Dec 2000 23:06:15 -0800
Message-ID: <3A31D9E7.B704A3B1@phatmorton.com>

Completely new to Oracle and wish to "browse" around the databases currently installed....

I am a little familiar with mysql and have used commands like mysqlshow to show the current running databases. Is there something familiar in Oracle. How do you find out what databases and instances that are running?

How do you then select those databases or instances, to further issues commands. For instance, in mysql, I am use to using the "use databasename" command, where I could then execute "show tables;" then maybe simple SELECT statements on those tables.

Simply, using sqlplus how do I know what databases are installed, and how do I show them, select, them, then further show tables within that database to execute SELECT or whatever statements.

If you haven't noticed already, I'm confused...

Thanks for any help.

..n8 Received on Sat Dec 09 2000 - 01:06:15 CST