Re: Useful Oracle books - C.J. Date theory vs. practicality
- From: Nuno Souto <dbvision@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 29 May 2004 14:28:44 +1000
Jared.Still@xxxxxxxxxxx allegedly said,on 29/05/2004 5:23 AM:
Maybe I need a slug of Ardberg to understand.
You forgot that PL/SQL, unlike Cobol, has a NULL.
If the value being compared is NULL, you get a meaningless
result that still executes something in PL/SQL. While in
Cobol it simply can't exist therefore the problem
is never seen: there is no such thing as a NULL in ANY
data type in Cobol (last time I looked, anyway).
--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
- References:
- RE: Useful Oracle books - C.J. Date theory vs. practicality
- From: Jared . Still
Other related posts:
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » RE: Useful Oracle books - C.J. Date theory vs. practicality
- » Re: Useful Oracle books - C.J. Date theory vs. practicality
Maybe I need a slug of Ardberg to understand.
You forgot that PL/SQL, unlike Cobol, has a NULL. If the value being compared is NULL, you get a meaningless result that still executes something in PL/SQL. While in Cobol it simply can't exist therefore the problem is never seen: there is no such thing as a NULL in ANY data type in Cobol (last time I looked, anyway).
- RE: Useful Oracle books - C.J. Date theory vs. practicality
- From: Jared . Still