Re: How long are my LONGs?
From: <sstephen_at_us.oracle.com>
Date: Wed, 21 Oct 1992 21:27:07 GMT
Message-ID: <1992Oct21.132707.1_at_us.oracle.com>
Date: Wed, 21 Oct 1992 21:27:07 GMT
Message-ID: <1992Oct21.132707.1_at_us.oracle.com>
In article <BwFL21.2py_at_well.sf.ca.us>, mharper_at_well.sf.ca.us (Michael J. Harper) writes:
> Now that I have added my solitary LONG column to a table, is there a way
> to find out how LONG the data is on a per row basis? Silly me, I thought
> I could use something like LENGTH() or VSIZE(), but both choke when given
> the name of a LONG column. I am looking for the length of the *actual data*,
> not the maximum length of a LONG column.
>
> Any other thoughts?
>
> Michael J. Harper
> mharper_at_well.sf.ca.us
-- Under V6, the only way to detect the length would be to select the column into a variable, then check the length field. It is for this very reason that SQL*Forms and SQL*ReportWriter, which use LONG columns, also store the length of data in the row when it stores the value. ================================================================================ Scott Stephens inet: sstephen.us.oracle.com Oracle WorldWide Support Redwood City, CaliforniaReceived on Wed Oct 21 1992 - 22:27:07 CET