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!

How to loop through comma separated string

User_Q4W7BJul 16 2021

I have a string like:
1295031561,07/06/2021
1377058140,07/06/2021
1603302580,07/09/2021
1025937542,07/06/2021
1078676830,07/09/2021
I need to loop through the values. The first # is the id and the second is a quit date. I thing need to update the values in a table
Update UserTable
SET QuitDate = '07/06/2021'
WHERE ID = 1295031561

Added on Jul 16 2021

7 comments

3,654 views