Forum Stats

  • 3,839,027 Users
  • 2,262,440 Discussions
  • 7,900,836 Comments

Discussions

Error Message (ORA-00933: SQL command not properly ended) whenever using multiple CTE's

Has anyone else had problems using executing SQL code with multiple CTEs in Oracle Developer Tools for VS Code?

I'm able to get the results for a single CTE but when if I'm referencing more than one, the Oracle extension seems to try to execute each CTE individually instead.

Any help would be appreciated!

Answers