I've written a lot of code blocks in the Saved SQL portion of the Command Processor in ApEx 5.1. I'd like to be able to export all of it. It's got to be stored some place in the database. Is it possible to find it?
I tried the below code to get a row count of all user tables. I figured I could find the table with the same number of Saved SQL blocks but it didn't work. Any ideas? Thank you.
Bill
declare
cursor c1 is select * from dictionary where table_name like 'USER%';
p_count number(5);
p_sql varchar2(300);
begin
for a1 in c1 loop
p_sql := 'select count(1) from ' || a1.table_name;
execute immediate p_sql into p_count;
if p_count > 0 then
htp.p(a1.table_name || ' - ' || p_count);
end if;
end loop;
end;