Re: Warning about null and open question to Oracle

I believe that in Oracle version 5 (??possibly??) you COULD compare a value to null.

However, the behaviour used by Oracle with respect to NULL now is to comply with the current ANSI standard.

Saying that "it's a pain to do a separate check that a value is NULL" is like saying "it's a pain to check whether a value is CHAR or NUMBER". In other words, you can't put a NUMBER variable straight into a function designed for CHAR values, you need to put a TO_CHAR() round it. The same with NULL.

Oracle provides all the necesary tools to check/compare null values - so use them.

Peter

-- 

|~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|


| PETER  MOORE  | pt_at_chaff.demon.co.uk       | "Either he's dead, or my watch |


|     DBA       |                            |  has stopped!" - Groucho       |

| MAT Transport | +44 (171) 410 6373         |                                |

|_____________________________________________________________________________|