How do I format the Join clauses to be on their own lines, vertically stacked, with the On clause on the same line as the Join clause?
WORKAROUND:
None
STATUS:
Enhancement request ST 57122 has been submitted to Development for consideration in a future release of Toad for Oracle.
Example:
Current Formatting:
select jobs.*, employees.*
from hr.jobs join hr.employees on (jobs.job_id = employees.job_id) join hr.employees
on (upper(jobs.max_salary) = upper(employees.salary))
join hr.employees
on (jobs.job_id = employees.job_id)
join hr.employees
on (upper(jobs.max_salary) = upper(employees.salary));
The desired formatting:
select jobs.*, employees.*
from hr.jobs
join hr.employees on (jobs.job_id = employees.job_id)
join hr.employees on (upper(jobs.max_salary) = upper(employees.salary))
join hr.employees on (jobs.job_id = employees.job_id)
join hr.employees on (upper(jobs.max_salary) = upper(employees.salary));
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center