Re: How to select Database in Oracle??

Hi Mike,
The concept of a database is different in some other software than in Oracle...you may be referring to a schema...in Oracle you can have several schemas (designated with a username/password) in one database and most users can only, by default, see the things they create..access to different databases is done by connecting to a database through the login box that opens when you launch an app like SQL*Plus and specifying a host string...this can also be done on the command line, but it's the combination of the user/password and service name that will connect you to another database.

Steve

Mike Hunt wrote:

> I just changed database to Oracle from PostgreSQL.
> In PostgreSQL, I can select which database to use like $ psql database_name.
> (or "\connect database" in psql.)
> But Oracle seems doesn't have option for select database.
> All they talking about is table in the book.
>
> What are the commands for select database and list the tables in sqlplus?
>
> SVP help me.
> Thanks in advance.
Received on Fri Apr 27 2001 - 13:00:59 CDT