Xref: alice comp.databases.oracle.misc:21049
Path: alice!news-feed.fnsi.net!newsfeed.wli.net!newsfeed.direct.ca!cyclone.bc.net!rover.ucs.ualberta.ca!sas.ab.ca!suisum
From: suisum@freenet.edmonton.ab.ca ()
Newsgroups: comp.databases.oracle.misc
Subject: Is there any HIGH_VLAUE or LOW_VALUE for numeric comparision
Date: 10 Oct 1998 15:05:32 GMT
Organization: Edmonton FreeNet, Edmonton, Alberta, Canada
Lines: 17
Message-ID: <6vnt3s$emk$2@news.sas.ab.ca>
X-Trace: news.sas.ab.ca 908031932 15060 198.161.206.7 (10 Oct 1998 15:05:32 GMT)
X-Complaints-To: news@sas.ab.ca
NNTP-Posting-Date: 10 Oct 1998 15:05:32 GMT
X-Newsreader: TIN [version 1.2 PL2.6]

Hi:

If I want to trap the NULL numeric value, I want it compare with the
HIGH_VALUE to avoid the following situation. For instance,


  v_number        NUMBER(5)  := 99999;
  v_compare_value NUMBER(10) := NULL

  If NVL(v_number, 99999) = NVL(v_compare_value, 99999) THEN
    do somthing;
  END IF;

The above statement will be TRUE as they are both 99999.

--
Best regards,