Paramiterize your scripts and queries.
Huh?
Well……

You can make your saved scripts and queries prompt you for the data you need instead of keying it in and then running the query.
Very useful for some of our everyday queries like

select * from course_main where course_id=’My course’
select * from course_main where pk1=1234

You would do write your queries like such.

select * from course_main where course_id=’\&course_id’
select * from course_main where pk1=&pk1

Then when you run these window will pop up where you will insert the name or the pk1 value.

Seems like in Oracle sql Developer this is about on and seems to work the same.

In Aqua Data you have to flip some switches but here’s the link to read up on all of it.

http://docs.aquafold.com/ads/8.0/41212888-E5F6-5E5A-38CF-E1DEDE7A0EE1.html