Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL help needed

RE: SQL help needed

From: David Boyd <davidb158_at_hotmail.com>
Date: Mon, 10 Jul 2006 14:51:05 -0400
Message-ID: <BAY101-F77D0C432D18841D801429EF6B0@phx.gbl>


Ken,

Thanks for your input. As you pointed out, I'll stay with the long SQL statement to eliminate overhead.

Dave

>From: "Ken Naim" <kennaim_at_gmail.com>
>Reply-To: <kennaim_at_gmail.com>
>To:
><kennaim_at_gmail.com>,<davidb158_at_hotmail.com>,<mwf_at_rsiz.com>,<oracle-l_at_freelists.org>
>Subject: RE: SQL help needed
>Date: Mon, 10 Jul 2006 13:02:44 -0500
>
>Ignore my last email as I misread yours as I didn't consider that a long
>sql
>statement. The only other way would be to encompass that logic in a
>function
>but you would be adding a lot of overhead into the query due the context
>switches even if you made it deterministic.
>
>Ken Naim



Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 10 2006 - 13:51:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US