RE: SQL help needed


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: