How To Write Query in Toad for Oracle?

You can write queries using SQL Editor in Toad for Oracle. Follow these steps:

Write Query in Toad for Oracle

  1. Open Toad and connect to the Oracle database.
  2. Then click on the menu Database > Editor.
  3. An SQL Editor window will open.
  4. Here you can write the SQL queries as you write in SQL*Plus.
  5. After completing the query press Ctrl+Enter or F9 to execute.
You can also format the SQL query in the Editor by pressing the Shift+Ctrl+F key combination or by clicking on the menu Edit > Format Code. Below is an example of a formatted SQL query:

  SELECT EMPLOYEE_ID,
         FIRST_NAME,
         LAST_NAME,
         EMAIL,
         PHONE_NUMBER,
         HIRE_DATE,
         JOB_ID,
         SALARY,
         COMMISSION_PCT,
         MANAGER_ID,
         DEPARTMENT_ID
    FROM hr.employees
   WHERE department_id = 90 AND manager_id = 100
ORDER BY employee_id;

Create SQL queries in Toad for Oracle

Learn how to write SQL query in Toad for Oracle. A step-by-step guide to write, format and execute queries in Toad.