I know MS Access SQL, PL-SQL syntax has me stumped. This one should be simple, but…
I want to add a Where JOB_DESC does not begin with “…”, we have sub-classes of job desriptions all starting with 3 periods & I want to only grab the top level jobs, no “…” at the front.
sourceType=SQL source=’SELECT JOB_NAME, JOB_DESC
FROM JOB ORDER BY JOB_NAME’
In Access I could have used
1. Left(Job_Desc,3)<>“…”
2. Job_Desc not like “…” & “*”
etc; etc.
How do I accomplish thisin PL-SQL?
Other facts: J2EE environment, Oracle 8 database.
Thanks!