Re: Foreign key in Oracle Sql

From: <ak_tiredofspam_at_yahoo.com>
Date: 14 Jan 2005 20:01:12 -0800
Message-ID: <1105761672.869175.159530@c13g2000cwb.googlegroups.com>

>> What do you mean there is no VARCHAR2? Are you saying there are no
variable length strings in SQL?
..<<

it's called VARCHAR

>> Are you saying NULLS should propagate
as strings?
..<<

Well, I don't have a middle name, which is a very different situation from unknown middle name, correct? So I fail to see the logic in Oracle's inability to distinguish between a known empty string and an unknown one

SELECT COALESCE('', 'Null') FROM DUAL;

Null

What do you think? Received on Fri Jan 14 2005 - 22:01:12 CST