create table tablef
(
last_name varchar2(30),
first_name varchar2(30),
long_data long
);


insert into tablef values ('EDWARDS', 'ED', 'mrMY1234');


declare
in_var_long_data long;
begin
select long_data into in_var_long_data from tablef;
dbms_output.put_line(in_var_long_data);
dbms_output.put_line(length(in_var_long_data));
end;
/




-----Original Message-----
From: Teffany Harris
[mailto:oracledba-ezmlmshield-x15040124.[Email address protected]
Sent: Thursday, July 15, 2004 4:51 PM
To: LazyDBA Discussion
Subject: Max Length of long field


Can anyone send me a script that would give me the maxlength of a long
field?



Is there a way to do it with PL/SQL?



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page