Oracle SQL CTE not working - any workarounds???

Hi ArtieLadie ,

To work around the ORA-00923 error, you can check the following points:

1.Correct the syntax. Make sure you have placed the keyword FROM in its correct place, and that no spelling errors have occurred

2.If you used quotation marks in an alias, make sure that they have properly enclosed the alias and that they are double quotation marks.

3.Make sure no reserved words were used as an alias. See the Oracle appendix for reserved words to view a complete list. 

You can learn more: http://www.dba-oracle.com/t_ora_00923_from_keyword_not_found_where_expected.htm

                                     https://www.tekstream.com/oracle-error-messages/ora-00923-from-keyword-not-found-where-expected/

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.