Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL help needed
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 10 2006 - 13:51:05 CDT
![]() |
![]() |