| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Fwd: Size of Long Column
Try using utl_raw.length in PL/SQL.
Below is an example:
SQL> desc long_test
Name Null? Type
LONG_VAR
SQL> set serveroutput on
SQL> DECLARE
2 v_length NUMBER;
3 CURSOR C_LONG IS SELECT LONG_VAR FROM LONG_TEST;
4 BEGIN
5 FOR AROW IN C_LONG LOOP
6 v_length := utl_raw.length(AROW.LONG_VAR);
7 dbms_output.put_line('[' || AROW.LONG_VAR || ']' || ' :
' || v_length);
8 END LOOP;
9 END;
10 /
[This is only a test] : 19
[I need a second job badly] : 25
PL/SQL procedure successfully completed.
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: "Michael Chan" <micchan_at_visto.com>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 10/13/00 11:30:21 AM
>
>
>Hi,
>
>Is there any way to determine the "used" size of a long column
similar to
> vsize for other types of column ?
>
>Thanks,
>Michael
>
>
>_________________________________________________________________________
>__
>Visit http://www.visto.com/info, your free web-based communications
cente
>r.
>Visto.com. Life on the Dot.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Michael Chan
> INET: micchan_at_visto.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing
Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>
 |
 |