Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to save models of sql scripts in PL/SQL Developer

Mark1970May 14 2010 — edited May 14 2010
I 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!
This post has been answered by Saubhik Banerjee on May 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2010
Added on May 14 2010
2 comments
1,243 views