When trying to run Code Analysis on a SQL query that has a PIVOT clause, a syntax error is reported.
'[Error] Syntax check (72: 42): Found: 'pivot' Expecting: ; -or- FOR ORDER -or- INTERSECT MINUS UNION -or- CONNECT GROUP HAVING MODEL START -or- , FULL INNER JOIN LEFT RIGHT WHERE -or- CROSS NATURAL PARTITION'
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy