How to Autocomplete Commands in Toad for Oracle?

How to Autocomplete Commands in Toad for Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.
  • Toad
  • 2 mins read

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: