Ken,
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
-- //www.freelists.org/webpage/oracle-l