Hi, i was trying to do something like this

Update zsqltemp
set EXECUTIONS= EXECUTIONS -LAST_EXECUTIONS + s.EXECUTIONS ,
LAST_EXECUTIONS= s.EXECUTIONS
from zsqltemp z inner join sqltemp s on
s.ADDR=z.ADDR
WHERE z.LAST_EXECUTIONS < (select EXECUTIONS from sqltemp d where
d.ADDR=z.ADDR);

This works fine in SQL Server, but Oracle doens't support it.
How can i implement something like this in oracle. i 'm trying to avoid
this:

Update zsqltemp z
set EXECUTIONS= EXECUTIONS -LAST_EXECUTIONS +(select EXECUTIONS from
sqltemp s where s.ADDR=z.ADDR),
LAST_EXECUTIONS=(select EXECUTIONS from sqltemp s where s.ADDR=z.ADDR)
WHERE z.LAST_EXECUTIONS < (select EXECUTIONS from sqltemp d where
d.ADDR=z.ADDR);

In this statement i have to reuse the value of this subquery many times
(select EXECUTIONS from sqltemp s where s.ADDR=z.ADDR).

Saludos
Christian I. Sánchez Noriega
Equipo BASIS SAP
Belcorp - TI
Mail: [Email address protected]
Fono: 2113300 (1629)


Oracle LazyDBA home page