Can't run the following code, editor says there is a syntax error and refuses to attempt to run it, however this works fine when run using another IDE (eg. TOAD).
The following SQL gives the error below
CREATE VIEW PLAYERDASHBOARD.THIS_WONT_WORK AS
WITH L AS (SELECT * FROM DW.LOCALE)
SELECT * FROM L;
[-104] An unexpected token "END-OF-STATEMENT" was found following "RD.THIS_WONT_WORK AS". Expected tokens may include: "<query_expr>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.7.85
I tested this exact example using TOAD which worked fine.
The statement does run successfully without the view part.