Press "Enter" to skip to content

How to Autocomplete Commands in Toad for Oracle?

In Toad for Oracle, use Auto Replace option to create autocomplete shortcuts for most frequently used Oracle commands such as SELECT * FROM, DBMS_OUTPUT.PUT_LINE and SET SERVEROUTPUT ON, etc. For example, you want that whenever you type SSF in Toad’s SQL Editor, then it should get replaced by SELECT * FROM. Follow these steps to set autocomplete commands in Toad.

Steps to Autocomplete Commands in Toad For Oracle

  1. In Toad for Oracle, click on the menu View > Toad Options.
  2. The Options window will open, then click on the Behavior node under Editor and there you will find the Auto Replace button. Click on this button and then a window will open as shown in the below image:

Create autocomplete shortcuts for Oracle commands in Toad for Oracle.

  1. Click on the Add button to insert a new row in the grid and then create the shortcuts to autocomplete for the commands you want as shown in the above image. Then click on the OK button to save.

Now when you will type the SSF (in lowercase or uppercase) and will press the SPACEBAR, then it will auto replace to SELECT * FROM and DD for DBMS_OUTPUT.PUT_LINE and SS for SET SERVEROUTPUT ON.

See also:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community for developers and ask your question. It is FREE.

Vinish Kapoor


Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Inline Feedbacks
View all comments