Return
-
Title
Formatting style for JOIN in FROM clause, to word wrap instead of starting a new line at ON. -
Description
Currently, formatter is formatting the script as shown here:
FROM home_tbl LEFT JOIN a_tbl ON a_pidm = home_pidm LEFT JOIN b_tbl
ON b_tbl.pri_pidm = a_primary_pidm AND max_year < fiscyear
LEFT JOIN c_tbl
ON c_tbl.pidm = home_pidm
LEFT JOIN d_tbl
ON d_tbl.pidm = home_pidm
LEFT JOIN e_tbl
ON e_tbl.pidm = home_pidm... the ON indents on a new line for each JOIN. But when there are more than one JOIN, it is preferable to have it not start a new line. Sample shown below:ÂFROM home_tblLEFT JOIN a_tbl ON a_pidm = home_pidmLEFT JOIN b_tbl ON b_tbl.pri_pidm = a_primary_pidm AND max_year < fiscyear
LEFT JOIN c_tbl ON c_tbl.pidm = home_pidm
LEFT JOIN d_tbl ON d_tbl.pidm = home_pidm
LEFT JOIN e_tbl ON e_tbl.pidm = home_pidm
Is it possible to define this in the formatting settings? -
Cause
Not an option in formatter at this time.
-
Resolution
WORKAROUND:
none
STATUS:
Enhancement request ST72909 has been submitted to Development for consideration in a future release of Toad for Oracle.
-
Defect ID
ST72909