Return
-
Title
Lookup Error: ORA-00904: "SUBSTRING" when running SQL Statement in Toad -
Description
Toad is not recognizing the following query:SELECT * FROM JOBS JSINNER JOIN EMPLOYEES EMP ON JS.JOB_ID = EMP.JOB_ID AND MIN_SALARY = 4200WHERE JS.JOB_ID = 'AC_ACCOUNT'AND SUBSTRING(TRIM(NVL(JS.JOB_TITLE,'')),14,1) IN ('T')See image below:
Lookup Error: ORA-00904: "SUBSTRING"
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.