Re: Foreign key in Oracle Sql
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 14 Jan 2005 20:20:14 -0800
Message-ID: <41e899f3$1_1_at_127.0.0.1>
>>-CELKO- wrote:
>>
>>>>>What are the right data types? <<
>>>
>>>See SQL Standards for the list. There is no VARCHAR2() or NUMBER(),
>>>NULLs propagate in strings, there are both FLOAT and REAL, etc.
>>
>>What do you mean there is no VARCHAR2? Are you saying there are no
>>variable length strings in SQL? Are you saying NULLS should
>>propagate as strings? So a NULL of a numeric or date data type
>>should be converted to a string by the SQL engine?
Date: Fri, 14 Jan 2005 20:20:14 -0800
Message-ID: <41e899f3$1_1_at_127.0.0.1>
Christopher Browne wrote:
> The world rejoiced as DA Morgan <damorgan_at_x.washington.edu> wrote: >
>>-CELKO- wrote:
>>
>>>>>What are the right data types? <<
>>>
>>>See SQL Standards for the list. There is no VARCHAR2() or NUMBER(),
>>>NULLs propagate in strings, there are both FLOAT and REAL, etc.
>>
>>What do you mean there is no VARCHAR2? Are you saying there are no
>>variable length strings in SQL? Are you saying NULLS should
>>propagate as strings? So a NULL of a numeric or date data type
>>should be converted to a string by the SQL engine?
> > > No, the point is that Oracle has nonstandard types.
It also has standard types. What's the point? That those using the product should have their hands tied behind their backs and not be able to creatively utilize functionality until it is blessed by a bunch of guys sitting around a table?
Of course it also has the ability for the user to define their own data types and I think that is what really ticks some people off.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Jan 15 2005 - 05:20:14 CET