Re: Checking LONG datatype for NULL

Also, In sql*plus there a "set null <string>" command that sets the printout result of a null to that string In forms maybe you can use the default value hope it helps

                    Yoram Z.

In Article<4i94jq$92q_at_romeo.logica.co.uk>, <marrowm_at_logica.com> write:
> Path:

news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.i nternetmci.com!iol!tank.news.pipex.net!pipex!dish.news.pipex.net!pipex!logica.c o.uk!p00894
> From: marrowm_at_logica.com (Matt Marrow)
> Newsgroups: comp.databases.oracle
> Subject: Re: Checking LONG datatype for NULL
> Date: 14 Mar 1996 12:48:58 GMT
> Organization: Logica UK Ltd.
> Lines: 28
> Message-ID: <4i94jq$92q_at_romeo.logica.co.uk>
> References: <4i74bf$sp3_at_cbisinet.cbis.com>
> NNTP-Posting-Host: 158.234.56.189
> To: gburton_at_cbis.com
> X-Newsreader: News Xpress Version 1.0 Beta #3
>
> Why not use the clause 'WHERE <long column name> IS NULL'?
>
> For instance:
>
> SELECT site_name "SITES WITH NO LONG DESCRIPTION"
> FROM sites
> WHERE long_description IS NULL;
>
> Hope this is of use
>
> Matt
>
> marrowm_at_logica.com
>
> All views are mine and do not necessarily reflect those of my employer.
>
> In article <4i74bf$sp3_at_cbisinet.cbis.com>,
> gburton_at_cbis.com (Glenn Burton) 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?
> >
> >Thanks in Advance!
> >
Received on Sun Mar 17 1996 - 00:00:00 CET