How to resolve ORA 00936 Missing Expression Error

Question

Select    USE HASH  a b      to char date   MM DD YYYY HH24 MI SS   as LABEL  ltrim rtrim substr oled  9  16    as VALUE  from rrfh a  rrf b  where ltrim rtrim substr oled  1  9       stata kish   and a xyz   b xyz    The  from    3rd line  part of the above query is giving me ORA-00936 Missing EXPRESSION error  Please Help me   NOTE    rrfh table contains no data

User · Answer

This happens every time you insert  update and you don t use single quotes  When the variable is empty it will result in that error  Fix it by using     Assuming the first parameter is an empty variable here is a simple example   Wrong  nvl   0   Fix  nvl     0   Put your query into your database software and check it for that error  Generally this is an easy fix

User · Answer

This answer is not the answer for the above mentioned question but it is related to same topic and might be useful for people searching for same error   I faced the same error when I executed below mentioned query   select OR   from ORDER REL STAT OR  problem with above query was OR is keyword so it was expecting other values when I replaced with some other alias it worked fine

User · Answer

Remove the comma   select    USE HASH  a b      to char date   MM DD YYYY HH24 MI SS   as LABEL  ltrim rtrim substr oled  9  16    as VALUE from rrfh a  rrf b where ltrim rtrim substr oled  1  9       stata kish   and a xyz   b xyz   Have a look at FROM      SELECTING from multiple tables You can include multiple tables in the   FROM clause by listing the tables with a comma in between each table   name

User · Answer

update INC PROV CSP DEMO ADDR TEMP pd  set pd practice name         select PRSQ COMMENT FROM INC CMC PRSQ SITE QA PRSQ     WHERE PRSQ PRSQ MCTR ITEM    PRNM       AND PRSQ PRAD ID   pd provider id     AND PRSQ PRAD TYPE   pd prov addr type     AND ROWNUM   1

User · Answer

Remove the coma at the end of your SELECT statement  VALUE    and also remove the one at the end of your FROM statement  rrf b

[oracle] How to resolve ORA 00936 Missing Expression Error?

Examples related to oracle

Examples related to oracle10g

Examples related to ora-00936