Increase version number logic
I'm new to PL/SQL coding. I have a requirement as to insert employee feedback data to emp survey table. Now there are few conditions.
If an individual emp has more than one feedback version then we need to increase the version of feedback data in survey table if that feedback version already exist in survey table.
Can you please guide me with the logic here?
Regards,
Saurav