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


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


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!


Other related posts: