Question

Trying to run an sql query in VBA but every time I run the macro I get an error message stating " Run-time error’- 2147217900 (80040e14)’: ORA-00923: From keyboard not found where expected”. I am a newbie with using queries and am wondering if anyone knows what the problem is with the query I wrote and why I keep getting this error in VBA. Everything in my code works except this query so I know the problem has to be the query, I've run other queries in the same code and they work so I am curious what is the problem with this query.

This is the query that I am using:

SELECT STATEMENT

  HASH GROUP BY

    VIEW EDW.VCS_DEALER_TRADE_VW

      FILTER

        HASH GROUP BY

          VIEW EDW

            UNION-ALL

              HASH GROUP BY

                HASH JOIN

                  VIEW EDW.index$_join$_005

                    HASH JOIN

                      BITMAP CONVERSION TO ROWIDS

                        BITMAP INDEX SINGLE VALUE EDW.XIF005DEALER

                      INDEX FAST FULL SCAN EDW.IDX_DEALER

                  HASH JOIN

                    VIEW EDW.index$_join$_004

                      HASH JOIN

                        BITMAP CONVERSION TO ROWIDS

                          BITMAP INDEX SINGLE VALUE EDW.XIF005DEALER

                        INDEX FAST FULL SCAN EDW.IDX_DEALER

                    TABLE ACCESS FULL EDW.VCS_DEALER_ORDER_TRADE

              HASH GROUP BY

                NESTED LOOPS

                  HASH JOIN

                    HASH JOIN

                      TABLE ACCESS FULL EDW.VCS_DEALER_VT_TRADE

                      VIEW EDW.index$_join$_008

                        HASH JOIN

                          BITMAP CONVERSION TO ROWIDS

                            BITMAP INDEX SINGLE VALUE EDW.XIF005DEALER

                          INDEX FAST FULL SCAN EDW.IDX_DEALER

                    VIEW EDW.index$_join$_009

                      HASH JOIN

                        BITMAP CONVERSION TO ROWIDS

                          BITMAP INDEX SINGLE VALUE EDW.XIF005DEALER

                        INDEX FAST FULL SCAN EDW.IDX_DEALER

                  TABLE ACCESS BY INDEX ROWID EDW.VCS_VEHICLE

                    INDEX UNIQUE SCAN EDW.XPKVCS_VEHICLE

              HASH GROUP BY

                FILTER

                  HASH JOIN

                    TABLE ACCESS FULL EDW.VCS_DLR_ORDER

                    VIEW EDW.index$_join$_011

                      HASH JOIN

                        BITMAP CONVERSION TO ROWIDS

                          BITMAP INDEX SINGLE VALUE EDW.XIF005DEALER

                        INDEX FAST FULL SCAN EDW.IDX_DEALER

              HASH GROUP BY

                FILTER

                  TABLE ACCESS BY INDEX ROWID EDW.VCS_INVENTORY

                    NESTED LOOPS

                      MERGE JOIN CARTESIAN

                        TABLE ACCESS FULL EDW.LAST_BUSINESS_DAY

                        BUFFER SORT

                          TABLE ACCESS FULL EDW.DEALER

                      INDEX RANGE SCAN EDW.XIF192VCS_INVENT

Answer 1

When you are faced with this error, you will see the following message:

ORA-00923 FROM keyword not found where expected

ORA-00923 occurs when you try to execute a SELECT statement without a FROM keyword in its correct form and place. If you are seeing this error, the keyword FROM is spelled incorrectly, misplaced, or altogether missing. In Oracle, the keyword FROM must follow the last selected item in a SELECT statement or in the case of a REVOKE statement, the privileges. If the FROM keyword is missing or otherwise incorrect, you will see ORA-00923.

The Solution

To resolve ORA-00923, you should make sure three possible causes are corrected. First, you must correct the syntax. Make sure you have placed the keyword FROM in its correct place, and that no spelling errors have occurred. Secondly, if you used quotation marks in an alias, make sure that they have properly enclosed the alias and that they are double quotation marks. Lastly, make sure no reserved words were used as an alias.

Since you have not provided me the table names, I cannot provide you the exact solution over here. Please make sure that you have corrected the mistakes as stated above.