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: SQL Server 2000 Migrate to Oracle

Re: SQL Server 2000 Migrate to Oracle

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 29 Nov 2004 17:22:50 -0800
Message-ID: <1101777674.262975@yasure>


Niall Litchfield wrote:

> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message 
> news:1101709951.714111_at_yasure...
> 

>>HansF wrote:
>>
>>
>>>Someone wrote:
>>>
>>>
>>>
>>>>Just address the 30 character restriction and all is well. Simple as
>>>>that.
>>>>
>>>
>>>
>>>I still would prefer someone address the 18 char tablename restriction.
>>>Then have Oracle follow the resulting standard!
>>>
>>>/Hans
>>
>>SQL> desc obj$
>> Name Null? Type
>> ----------------------------------------- -------- ------------
>> OBJ# NOT NULL NUMBER
>> DATAOBJ# NUMBER
>> OWNER# NOT NULL NUMBER
>> NAME NOT NULL VARCHAR2(30)
>>
>>What am I missing?
> 
> 
> It isn't ANSI SQL compliant which requires 18 character or less UPPER CASE 
> identifiers. Hans wants the standard changed (upwards) and Oracle (and 
> others) to comply with the new standard. I wish him luck.

Thanks.

Sorry Hans ... 30 is enough for me and I fear that given more room ... people would use it. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 29 2004 - 19:22:50 CST

Original text of this message

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