Re: Useful Oracle books - C.J. Date theory vs. practicality

  • From: Nuno Souto <dbvision@xxxxxxxxxxxxxxx>
  • To: Oracle L <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 28 May 2004 22:34:01 +1000

-------- Original Message --------
jo_holvoet@xxxxxxxx wrote:

SAP doesn't use nulls. For char fields they typically use a single space, for dates (which they store in chars) they use '00000000', etc.etc.
And yes, it is every bit as ugly and horrendous as you describe ... I assume in their case it is partly a legacy issue and partly a database independence issue ?

Legacy. SAP was initially developed to run on flat ISAM files. Which have no clue what a NULL is. Their entire design has not evolved one bit since then.

--
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: