A lot of developers waste a long time writing repeated code,So Toad offers feature named "Code Template" that I can use it to overcome this.
To use code template in editor you must press CTRL+SPACE, it will show list of reserved code template as below, Then choose the required template
Here I will clarify how creating your own code template
1) From Menu View->Toad Options It will open the below window choose from left pane Editot->Behavior and from T-List choose PL-SQL and then press edit button as below
The following window will be shown, choose code template tab and then press add code as below
Aftter entering short name and description, click Ok and enter the following code as example in Text area that in previous photo
declareTo use that template in editor you click CTRL+Space it will show a list of template when you choose "select" it insert code that you entered before in editor.
when no_data_found then
--no data found exception
when too_many_rows then
--too many rows exception
when others then
You can import and export your own code template from toad at your machine to another machine using Import and Export buttons as following photo
I hope that my post is helpful and useful.
If you have any question, Feel free to ask at email email@example.com