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

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 04 Nov 2006 16:04:18 -0800
Message-ID: <1162685055.401815@bubbleator.drizzle.com>

hasta_l3_at_hotmail.com wrote:
> DA Morgan wrote :
>

>> hasta_l3_at_hotmail.com wrote:
>>
>>> However, one could very naturally be led to give the same name
>>> to a table and to a package - ie an "employee" table and the
>>> corresponding "employee" package.
>> CREATE TABLE employee ....

>

>> A name should have meaning.

>
> The point was that the names of the problem domain
> are necessary but not sufficient to drive the naming of
> oracle objects.
>

SQL> desc user_source

  Name                                      Null?    Type
  ----------------------------------------- -------- --------------
  NAME                                               VARCHAR2(30)
  TYPE                                               VARCHAR2(12)
  LINE                                               NUMBER
  TEXT                                               VARCHAR2(4000)

SQL> You have up to 30 characters ... use some imagination. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Nov 04 2006 - 18:04:18 CST