Re: Oracle treatment of fully qualified names
From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 14 Jan 2003 19:46:09 +0100
Message-ID: <3E245AF1.8010508_at_netscape.net>
Date: Tue, 14 Jan 2003 19:46:09 +0100
Message-ID: <3E245AF1.8010508_at_netscape.net>
Jim Kennedy wrote:
> 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
>
Well, to complete Peters' comments on databases:
scott.emp_at_orcl.
Orcl being the network alias for the database;
scott.emp_at_hq would be an entire different database
Frank Received on Tue Jan 14 2003 - 19:46:09 CET