Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Oracle Enforce Name Uniquness ???!!!

Re: Why Oracle Enforce Name Uniquness ???!!!

From: <hasta_l3_at_hotmail.com>
Date: 5 Nov 2006 13:19:38 -0800
Message-ID: <1162761578.164238.203080@h54g2000cwb.googlegroups.com>


Serge Rielau wrote :

> Food for thought.
> Serge

Serge, to perhaps give some food to your previous question :

> It certainly is an interesting question why
> Oracle lumps routines and packages into the
> same name space with tables.

consider that Oracle allows one to create a synonym for a package. Now, if package and table names were in different namespaces, then one would have funny ambiguities :

  create table employee...
  create package employee...
  create synonym emp for employee -- which one ?

Of course, this syntactic ambiguity could be somehow lifted. But then, things would become *really* funny. Indeed, one could very logically try to write :

  create synonym emp for table employee
  create synonym emp for package employee -- ??? two synonyms with same name ???

and therein lie dragons :-) Received on Sun Nov 05 2006 - 15:19:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US