How to fix ora 00936 missing expression?

  • Check that your column names are all listed correctly in the SELECT clause.
  • Ensure you have a FROM clause in your SELECT statement. ...
  • Remove any commas that shouldn't be in your query.
  • Lees verder »

How to resolve ora 00936 missing expression?

To resolve the ORA-00936 error: Check that your column names are all listed correctly in the SELECT clause. Ensure you have a FROM clause in your SELECT statement. Lees verder »

How to resolve temp space issue in Oracle?

Query the TEMP datafiles to check their details and segment number (TS#): SELECT FILE#, CREATION_TIME, NAME, BYTES / 1024 / 1024 AS SIZE_MB, TS# FROM V$TEMPFILE; Observation: The segment number (TS#) had changed from 4 to 36. After executing the updated query, the TEMP space was successfully released. Lees verder »

Gerelateerd aan How to fix ora 00936 missing expression?