current position:Home>Oracle a column of multi value update problem.

Oracle a column of multi value update problem.

2022-02-02 19:04:45 CSDN Q & A

Now there is a column , Suppose it's stored in 1,2,3 Split with a comma
But now I want to 123 Replace , hypothesis 1 Corresponding a,2 Corresponding b,3 Corresponding c, Yes 3 And special treatment , If only 3, Just replace it with empty , If yes 1,3, I want to replace it with a, That is, multivalued contains 3, To put 3 Delete , Now I want to process all the data in the database , How to write ?

Refer to the answer 1:

Write a stored procedure , Logical processing is implemented inside stored procedures .

Refer to the answer 2:

copyright notice
author[CSDN Q & A],Please bring the original link to reprint, thank you.

Random recommended