[ILUG] [OT] Oracle for beginners ?

[Martin Feeney]

On 20 Jan 00, at 10:38, Stephen_Reilly at dell.com wrote:

> "John P. Looney" wrote:
> > 
> >  Anyone know of an Oracle site for beginners ? The equivalents of
> >  the
> > following MySQL commands:
> > 
> >  use database;
> 
> >>er...
> this would be part of your login script, once you point to one server
> you can only point to one database. After that what you see are
> schemas, what the DBA has allowed you to see. The database is not
> named, its just Oracle and there can be only one. 

I know this is way off topic, but that's just wrong.  You can host as 
many databases as you have disk space for off one oracle 
instance.  

The command (via sqlplus) to connect to a different database would 
be:  

connect user/pass at dbname

if you setenv ORACLE_SID, that'll be the default database that's 
connected to.

There are lots of good O'Reilly books on Oracle.

A web site called "Oracle Underground" has many links to learning 
material.  I don't know the url off hand, but any good search engine 
should find it for you.