When I first formatted the SQL, I had not ever changed any option in Toad. But when my package did not format correctly, I did change the options. I isolated and simplified one SQL statement which causes the problem.
I cannot find the “options button on the top pane of the options gui.” (See picture below). But I got the content of the option file and some other info for you.
C:\Users\guo\AppData\Roaming\Quest Software\Toad for Oracle\12.0\User Files\FmtPlus.opt
How I formated the statement:
Highlight the SQL
click on formatting tools -> format
Here is the version I’m using:
Toad for Oracle Xpert version 126.96.36.199