When trying to run Code Analysis on a SQL query that has a PIVOT clause, a syntax error is report (88853)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

When trying to run Code Analysis on a SQL query that has a PIVOT clause, a syntax error is report
Description

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'
Resolution

WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of Toad for Oracle
Defect ID

CR 96055

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title