Re: Foreign key in Oracle Sql

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.

> And since when does Oracle not have both FLOAT and REAL? NUMBER() is a
> float. So is FLOAT. So is BINARY_FLOAT. And so is REAL.

REAL is certainly not representative of real numbers; any system designer with the combination arrogance _and_ mathematical ignorance to call a type "REAL" is richly worthy of derision.

That type can't represent real numbers; it can only represent some subset of rational numbers.

-- 
output = ("cbbrowne" "_at_" "gmail.com")
http://cbbrowne.com/info/rdbms.html
Signs of   a Klingon Programmer -   1.  "Defensive  programming? Never!
Klingon programs are always on the offense. Yes, offensive programming
is what we do best."