TOAD is reporting the attached SQL as invalid. The formatter is underining the 'union' of 'union all' . TOAD accepts the same code in TOAD 11.6 One has to comment this code out every time reformating the PL/SQL within which it resides, then uncomment it afterwords.
[Error] Syntax check (13: 80): ERROR line 13, col 80, ending_line 13, ending_col 84, Found 'UNION', Expecting: ) -or- FETCH OFFSET -or- ORDER
WORKAROUND:
Install Toad for Oracle 11.6.1 alongside version 12.0.
Use this version when you need to format code with 'UNION' statements.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
