Long Data type

Long data type in oracle can have character string up to 2G
Here is an example of inserting long datatype into varchar2 field.

- inserting long datatype into a varchar2
– setup
create table long_test (trig_name varchar2(2000), trig_body_str varchar2(2000));
– procedure to insert long to varchar2:
declare
tname varchar2(2000);
tbody varchar2(2000);
cursor aaa_cur is
select trigger_name, trigger_body
from sys.dba_triggers
where owner = ‘SBLIVE’;
begin
for aaa in aaa_cur loop
tbody := substr(aaa.trigger_body, 1, 1999);
insert into long_test
(trig_name, trig_body_str)
values
(aaa.trigger_name, tbody);
end loop;
end;