RE: SQL help needed

  • From: "David Boyd" <davidb158@xxxxxxxxxxx>
  • To: kennaim@xxxxxxxxx, mwf@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 10 Jul 2006 14:51:05 -0400

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@xxxxxxxxx>
Reply-To: <kennaim@xxxxxxxxx>
To: <kennaim@xxxxxxxxx>,<davidb158@xxxxxxxxxxx>,<mwf@xxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
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/


--
//www.freelists.org/webpage/oracle-l


Other related posts: