Re: basic browsing commands for oracle...

Sorry to say so, but evidently you think you can learn Oracle without reading manuals. That, however, is not true. Try reading the Getting started Manual and the Oracle Concepts Manual. Buy Oracle the complete reference. Ok, I admit it weighs a few lbs, but it will you show Oracle is much more than mysql. Mysql even doesn't support row level locking.
Btw Oracle doesn't have databases like sqlserver and mysql. Oracle has schemas.
Maybe you should just start out by working with the scott schema (password tiger) in order to get more familiar with Oracle.

Regards,

Sybrand Bakker, Oracle DBA

"Nathan Affleck" <n8_at_phatmorton.com> wrote in message news:3A31D9E7.B704A3B1_at_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:50:56 CST