Re: [sqr-users] Clob, sqr and sql variables

["George Jansen" <GJANSEN@aflcio.org>]

CLOBs allow you to check their NULL/NOT NULL status without the need for
PL/SQL:

SQL> create table whizbang (a number, b clob);

Table created.

SQL> insert into whizbang (a) values (1);

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> select count(*) from whizbang where b is null;

  COUNT(*)
----------
         3

SQL> c/null/not null
  1* select count(*) from whizbang where b is not null
SQL> /

  COUNT(*)
----------
         0



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users