Environment:
- Toad for Oracle Professional (11.0.0.116)
- Windows 7 64 bit
- Oracle 10g
- QPE v5.185.11230.41888
I have an SQL block that I am trying to format in a specific way and I am unable to get what I want. I have attached two .sql files. The first file (toad_formatted.sql) shows what I am able to achieve using my current formatter options, the second file (desired_format.sql) shows the output that I want. I have also attached my formatter options.
Is it possible for me to get the desired output? Which formatter setting(s) am I overlooking?
Thanks…
desired_format.sql (782 Bytes)
FmtPlus (1.17 KB)
toad_formatted.sql (632 Bytes)