Re: Checking LONG datatype for NULL
From: Jonathan Wayne Ingram <jwingram_at_whale.st.usm.edu>
Date: 1996/03/14
Message-ID: <4ia5ap$e5n_at_thorn.cc.usm.edu>#1/1
Date: 1996/03/14
Message-ID: <4ia5ap$e5n_at_thorn.cc.usm.edu>#1/1
Glenn Burton (gburton_at_cbis.com) wrote:
: I would like to write a query that prints a message when a column
: of datatype LONG is NULL. My first thought was to use NVL to check
: for the presence of NULL, but this function isn't compatible with
: the LONG datatype.
: Does anyone have a workaround that will permit the comparison of a
: LONG column with NULL?
How about the following:
if col_name IS NULL then
Of course, that's PL/SQl and not SQL, but that shouldn't pse a serious problem.
Jonathan Received on Thu Mar 14 1996 - 00:00:00 CET