How to save models of sql scripts in PL/SQL Developer
Mark1970May 14 2010 — edited May 14 2010I use PL/SQL Developer of Allaround Automations for developing in pl/sql.
I'd like to know if it's possible to save a template script. I mean if I want to save a query with reference to a certain table, I can write the sql and then to save it by means of the "Save as Standard Query" button. But what I'd like to do is, for example, to save a script like:
declare
cursor c_cur is
+select *+
from
--+
v_cur c_cur%ROWTYPE;
--+
begin
open c_cur;
loop
fetch c_cur into v_cur;
exit when c_cur%NOTFOUND;
--+
--+
end loop;
close c_cur;
--+
end;
+/+
and to be able to open it whenever I want. Is it possible to save such "model scripts" anywhere in PL/SQL Developer?
Thanks!