Re: How can i extract (substr(field,1,200) ) a substring on a long or long raw field
From: Arie Zevenbergen <aa.zevenbergen_at_consunet.nl>
Date: Sat, 25 Apr 1998 14:51:05 +0200
Message-ID: <6hsm6g$co5$1_at_news.worldonline.nl>
Date: Sat, 25 Apr 1998 14:51:05 +0200
Message-ID: <6hsm6g$co5$1_at_news.worldonline.nl>
Try something like this :
declare
cursor cur is select field from table;
var1 varchar2(32767);
var2 varchar2(32767);
begin
open cur;
fetch cur into var1;
close cur;
var2 := substr(var1,1,200);
end; Received on Sat Apr 25 1998 - 14:51:05 CEST