Funny, I get - SQL> select /*+ LOOKING_FOR_WORK */ 2 from dba_jobs 3 where (city='SEATTLE' and 4 job_type='CONTRACT' and 5 hourly_rate='LOTS' and 6 technical_environment='CHALLENGING') OR 7 personal_status='STARVING'; from dba_jobs * ERROR at line 2: ORA-00936: missing expression Maybe you need to look at how you present yourself in your resume. Wit Serdakovskij <freelists To: oracle-l@xxxxxxxxxxxxx @wit.kiev.ua> cc: Sent by: Subject: Re: DBA salaries rise oracle-l-bounce 07/02/2004 11:24 AM Please respond to oracle-l Hello, Mark, [...] > Not returning any rows from this query, but it should be returning data: > > select /*+ LOOKING_FOR_WORK */ > from dba_jobs > where (city='SEATTLE' and > job_type='CONTRACT' and > hourly_rate='LOTS' and > technical_environment='CHALLENGING') OR > personal_status='STARVING'; Try CBO (key word is COST). > Too many WHERE predicates? No, too small SELECT list. ;c) [...] -- wbr, Wit. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------