Re: Problem with recursive query
Posted by:
Rick James
Date: January 26, 2013 12:55PM
Thinking out of the box...
Instead of doing it recursively, consider sequentially. That is, when a change is required, make a new row(s). The rows would have a sequence number -- the row with the highest sequence (for a given invoice id) would be the currently valid one.
Subject
Views
Written By
Posted
3842
January 25, 2013 12:34PM
Re: Problem with recursive query
1194
January 26, 2013 12:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.