TOAD SQL Editor Useful Shortcuts

AshokTechnical TipsLeave a Comment

This will run only the SQL that your cursor is on. You do not need to highlight the line or the entire SQL statement; simply place your cursor anywhere inside the SQL statement and click SHIFT-F9.

This will verify (parse) the statement without executing it.

This will execute an explain plan on the current statement.

This will bring up your previous SQL statement. If you use SHIFT-F9 and are disciplined about keeping all iterations of executed statements in the screen, you will not need this that often, but it can really come in handy (especially when your TOAD “croaks” (aka terminates or freezes up) and didn’t get a chance to save your SQL).

Executes the selection or entire screen as a script.

This executes a “describe” on the object your cursor is adjacent to (i.e. a table). This is different from the “desc [tablename]” command, since it pops up a TOAD window that is well-designed with an easy UI for navigating the object — the “desc” command in SQL will work similar to using SQL Plus where it will just show details in the result grid pane.

This will initiate TOAD’s “intellisense” when writing SQL or PL/SQL. For example, if you are disciplined about aliasing table names and pre-pending the table names in your statements, upon typing “[tablename].”, you can type “CTRL-TAB” to see a list of columns to choose from. This list will show up if you wait long enough as well, but if you are a fast typist and/or impatient, and/or a productivity overachiever, you will find this addictive (and you find that you are using unfamiliar schemas often, this is the type of feature that will make you not want to go back to SQL Plus). Also, when you get the “dropdown” of columns, try holding “CTRL” while left-clicking the columns you need with your mouse…then, click enter and voil?; all the columns will show up in your SQL statement (I know this has really saved me some time in the past).


Redo. (Note, unlike Microsoft Office products, CTRL-Y does NOT perform as redo).

Leave a Reply

Your email address will not be published. Required fields are marked *