SHIFT-F9
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.

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

CTRL-E
This will execute an explain plan on the current statement.

F8
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).

F5
Executes the selection or entire screen as a script.

F4
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.

CTRL-TAB
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).

CTRL-Z
Undo.

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

Related Information:

1. TOAD for Oracle 9 or TOAD 10 - 64-bit Windows - ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

   I recently downloaded the new 10.x version of TOAD and could not connect to my databases. Still running TOAD 9.x,...

2. Oracle Materialized View DDL

   Are you a TOAD fanatic when it comes to “anything-Oracle”? If so, you probably realized that TOAD will not show...

3. Oracle Forms - Remove List Element from List Item

   This one is a little wily, so John suggested we post it. Removing a label/value from a dropdown should be...

4. Visual Studio 2008 (VS2008) - Common Keyboard Shortcuts

   When I did a quick search online, I found some keyboard shortcuts for Visual Studio 2008 that didn’t work for...

5. Oracle Rename Table - Example Syntax and Dependencies

   Renaming a table in Oracle is simple. Following is the generic Oracle table rename syntax: 1 ALTER TABLE current_table_name RENAME...

6. Oracle Rename Column - alter table, rename column Example SQL Syntax

   Following is simple example syntax for renaming a column to an Oracle table using "alter table" SQL:
    
   ALTER...

7. Oracle SQL Subselect Statements

   It is becoming more common that I find myself surprised by self-proclaimed, seasoned SQL developers who do not even understand...

8. Copy Table Columns and Data

   As you may know, in Oracle the syntax from creating a table that is the same as another is: 1...