Hi,
My requirement is to load a LONG datatype data value from one table to another as direct access does not work (DB: ORACLE).
eg.
SELECT *FROM ALL_VIEWS WHERE TEXT LIKE '%<SEARCH_STRING>%';
As an alternate we are creating a table and trying to insert in it from ALL_VIEWS as direct insert stmt does not work.
create table myviews(
OWNER VARCHAR2(150),
VIEW_NAME VARCHAR2(90),
TEXT CLOB
);
so we are using an anonymous block to insert the data in myviews :
begin
for i in (select owner, view_name, text from all_views)
loop
insert into myviews values (i.owner, i.view_name, i.text);
end loop;
end;
the above stmt works fine on sql prompt but does not respond well through shell script, though no syntax error is caught.
Is there anyway i can select directlt data from ALL_VIEWS
OR
solution to above anonymous block ?
Kindly assist. any help is appreciated.