Hi,
The Toad code formatter in Toad for Oracle 13.3 is producing an error when the SQL statement contains COLLATE.
Simple example:
SELECT *
FROM all_procedures
WHERE object_name LIKE '%proc%' COLLATE BINARY_AI;
De statement runs fine.
When formatting the code, an error is raised:
[Error] Syntax check (3: 34): ERROR: line 3, column 34, ending line 3, column 40:
Found 'COLLATE': Expecting: end-of-input -or- FETCH FOR OFFSET ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING MODEL START -or- OR -or- AND -or- ESCAPE -or- + - | || -or- * / MOD REMAINDER -or- ** -or- ( (+) AT DAY MULTISET YEAR