Re: how to check on the length of a LONG field?
From: -=< a q u a b u b b l e >=- <no email>
Date: Thu, 28 Oct 1999 01:00:07 +0100
Message-ID: <7v83mj$e12$5_at_news6.svr.pol.co.uk>
Date: Thu, 28 Oct 1999 01:00:07 +0100
Message-ID: <7v83mj$e12$5_at_news6.svr.pol.co.uk>
[Quoted] [Quoted] Danny Lee <dlee+_at_processa.inf.cs.cmu.edu> wrote in message
news:7v5n7d$als$2_at_goldenapple.srv.cs.cmu.edu...
> Hi, ORACLE experts:
>
> I am using oracle 8.0.5 and developer 2000 2.1.
> There is a LONG column in a table, and I want to know the size of that
column for every row in the table.
> Sometimes the content of the column may go beyond 32k bytes.
> How can this be done in PL/SQL under Forms 5.0?
>
> Thanks in advance.
SELECT my_unique_id, LENGTH(long_column) FROM my_table;
It wouldn't be very nice though! Received on Thu Oct 28 1999 - 02:00:07 CEST