Weird sql response, could not explain
- From: dd yakkali <dd.yakkali@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Jul 2010 16:12:09 -0700
Can someone help me explain this weird behaviour.
when a subquery has a syntactical error what happens to the parent query.
select job_id , job_run_id , job_run_status_id
from job_runs
where dataset_date = trunc(sysdate)
and job_id in
( select job_id from load_job_profiles where load_job_profile_id = 33244 )
and job_run_status_id <> 6
...
1714260 77168858 11
1714260 77168859 7
1714260 77168860 7
1714260 77168862 11
1714260 77168863 7
1714260 77168865 7
1714260 77168868 11
1714260 77168869 7
.....
gives me bunch of results.
where as I run
select job_id from load_job_profiles where load_job_profile_id = 33244
ERROR at line 1:
ORA-00904: "JOB_ID": invalid identifier
Thanks
Deen
Other related posts:
