Re: Oracle treatment of fully qualified names

Oracle != SQL Server.(or DB2)
The database is not "needed" because you can only connect to one database on a connection. You can refer to multiple schemas in a database. eg scott.emp where scott is the schema owner of the scott schema. So scott.emp is the fully qualified name.
Jim

"Peter Nolan" <peternolan9_at_eircom.net> wrote in message news:E2HU9.2775$V6.4428_at_news.indigo.ie...
> >
> >
> > Describe the Oracle equivalent of catalog.
> >
> Hi Frank,
> the ODBC documentation cites a number of functions that require 'catalog'
 as
> a parameter. In SQL Server 2000 when ODBC wants a 'catalog' what it wants
 is
> the database name. I am guessing that under Oracle 'catalog' has the same
> meaning, database name.
>
> In SQL Server select * from database.schema.table is a valid SQL
 statement,
> and if my memory serves me it is in DB2...but that was a long time
 ago....It
> doesn't look like it is in Oracle.
>
> Thanks
> Peter
> www.peternolan.net
>
>
Received on Tue Jan 14 2003 - 04:57:11 CET