SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Versioning in table

User_YLOM7Jun 15 2022 — edited Jun 15 2022

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?

Added on Jun 15 2022

2 comments

382 views