Re: Rearrangement of Conditions (sensitive)
From: craig sivils <casivils_at_lescsse.jsc.nasa.gov>
Date: 15 Jan 93 21:52:10 GMT
Message-ID: <casivils.727134730_at_node_508ba>
Date: 15 Jan 93 21:52:10 GMT
Message-ID: <casivils.727134730_at_node_508ba>
Oracle optimizer tis a strange beast and they modify it from release to
release. A possible answer to your problem is to use a decode statement
similar to
where c2/decode(c1,0,1,c1) and c1 > 0
(may have swapped c1 & c2)
Craig
Received on Fri Jan 15 1993 - 22:52:10 CET