How to get the current field value?
877666Jul 24 2011 — edited Jul 24 2011Hi dudes,
I need to build a query that returns the current value of a determined field. It's a bit tricky, beacuse this table has a trigger that updates this field constantly and for each update there's a new register. And I need to get this determined value from 5 days ago until now.
Could you guys help me?! I'm running @ 10g.
SELECT percod permissor, decnroser decoder, decfch data_status, decode(decsts,'X','não retornado',decsts) decoder_status
FROM
decode_log
WHERE
decsts = 'X'
AND decfch < (sysdate - 5)
ORDER BY percod ASC;
Thx