This content has been marked as final. Show 2 replies
You could employ View > Snippets for this.
Create a custom group, add your queries - document by name and/or mouse-over comments.
You could also save them as .sql files and use @filename to run them.
THat way they are available in SQLPlus and SQL Developer, and you can share them with other people.
You can use the environment variable SQLPATH (which accepts multiple directories) and/or the preference Database|Worksheet |Select default path to look for scripts (which only accepts one) to make things easier.