Re: DBA salaries rise

From: Thomas Day <tday6_at_csc.com>
Date: Fri, 2 Jul 2004 11:33:05 -0400
Message-ID: <OFDDF8E4CD.60FCAD9F-ON85256EC5.00555DC2@csc.com>

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_at_freelists.org                                                         
                      @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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 11:29:52 CDT