Hi,
I just need some ideas/suggestions on how to implement a "versioning" in my database table with sql developer.
My table has the following columns:
TBL_ID | DATA1 | DATA2 | VERSION_NO
--------------------------------------------------
1 | X | X | 0
--------------------------------------------------
1 | Y | Y | 1
As you can see, for every update made on one particular row of data, a new record is inserted, only with an incremented value of VERSION_NO. Can anyone suggest a good way to implement this in sql developer?