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

[Melody Sayles <Melody.Sayles@alaska.edu>]

George and Edwin,
Thank you for your answers. Obviously I was making it much harder than it needed
to be!
Melody

edwin.hommes@bluewin.ch wrote:

> Rather than moving LONG field values around, especially if you only want
> to know whether or not it contains a value, you could use a simple oracle
> select.
> example
> select *
> from table
> where LONG_field is not null;
> This returns only those rows which have a value in their long field.
> hope this helps.
>
> >Subject: [sqr-users] Clob, sqr and sql variables
> >Date: Mon, 31 Jan 2005 14:47:29 -0900
> >To: sqr-users@sqrug.org

> >I'm using an sqr program to create a report based on a table where one of

> >the
> >columns is a CLOB. I found the DBMS_LOB.GETLENGTH function. All I need from
> >the
> >clob column is if there is text in there or is it null.



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