Hello DBAs,

Some days back I have asked a solution for tracking stock
position, since I don't see a reply, let me ask once more.

The condition is, there exist a stock table that contains stock quantity,
that's used as current stock, but we need the stock position of a specified
date, for this I've created a trigger to log the existing quantity to
another table with SYSDATE when an update occurs to stock table.

The problem is I have to take the MIN(Dates) from the <specified
date> to current date for each item to function.

Please advice me for improvements.



Warm regards

Bijoy V






Oracle LazyDBA home page