Querry does not pass in optimizer. Basically, the query runs correctly in a Toad session, but the optimizer reports a syntax error when encountering the PIVOT syntax.
ERROR:
The Parser did not identify the text as a valid SQL statement.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy