Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Weird Query

Re: Weird Query

From: AK <AK_TIREDOFSPAM_at_hotmail.COM>
Date: 1 Aug 2005 10:53:07 -0700
Message-ID: <1122918787.761028.225540@o13g2000cwo.googlegroups.com>


>>You know, the '' is equivalent to NULL.
<<

I have some reservations, such as:

situation A:
First Name: 'John'
Middle Name: '' (unknown, not a required field) Last Name: 'Smith'

situation B:
First Name: 'Igor'
Middle Name: '' (a known fact: no middle name at all. Russians do not have middle names. Patronymic names are not middle names) Last Name: 'Petrov'

how would you distinguish between situations A and B? Received on Mon Aug 01 2005 - 12:53:07 CDT

Original text of this message

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