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：
author[CSDN Q & A],Please bring the original link to reprint, thank you.
The sidebar is recommended
- A small problem about string 
- Python fastobjectlistview cannot operate on setitem * *
- What should I fill in at the crosswalk
- College C language programming c + + Programming
- Appium + Python + Android JDK failed to connect to the mobile phone to run app
- I think the activity can be started in the background above Android Q. how to realize it
- Use the predict type parameter to define a method for filtering books
- Problems related to the use of C PropertyGrid
- How to set the gain & lt^ u
- Click one H5 item in the app to jump to another H5 item
guess what you like
Find a solution to the error of this r code
Python will test Put the PY file in a python package (such as D: \ TT), import the package test in test2, and output the value of the variable data.
When using PPO strategy to train reinforcement learning model, how to evaluate the quality of the model and judge whether it converges?
Calculate the number of uppercase letters, lowercase letters and numbers in any string
If you work from home, the same operation will fail
Content encapsulation under three-level classification of Java
The idea switches branches and the project directory structure disappears
1. Customize a - function to realize the following functions: input the accuracy e, and use the following formula to calculate the approximate value of cosx until the absolute value of the last - item is less than E. It is required to define and call the
Find its Huffman code? Give the coding process and coding results (please give the large probability as 1 and the small probability as 0) Calculate the average code length. Calculate the compression ratio before and after coding
C language and documents to solve students' performance problems
- C language file encryption applet problem
- Three types of MPEG images
- How to write this program code
- Questions about data structure: data structure sequence table (language-c language)
- A problem of energy economics
- Vscode why does Python have two problems when the external window is running? Press any key to continue?
- Using 7474n to build JK Trigger and D trigger.
- C language two-dimensional array, for interpretation
- When simulating with botu and factory IO, factory IO I2 The contacts behind 0 are not working
- How to solve termux qqbot error?
- C + + getline cannot correctly read the console input Chinese
- Android development bookkeeping
- About the problem of C language: input 12 + 3 with DEVC + + to get 12.000000. I don't know what's wrong, include & lt; stdio. h＆gt;
- Prompt the user to enter an integer n and N real numbers, calculate and output the sum of the negative numbers in the input n real numbers.
- Using C52 and LCD1602 to simulate an electronic clock, how to program four modes and one LED flashing for four keys
- Do any friends know how to do this? Please
- For problems occurred during GCN reproduction, it is suggested that the openposedemo file cannot be found
- TypeError: string indices must be integers
- I really can't find answers to the exercises after freshman class.
- How is the MSE value compared with the vector?
- How to set a draw when making tic tac toe chess in Python
- Solving Python language C language
- How does Maple set a variable to be any integer from a certain interval
- How to realize that the opening of a website computer is one interface and the opening of a mobile phone is another interface, similar to self adaptation?
- After entering two indefinite length arrays and sorting them, merge and sort the two arrays again
- The computer has a web, but it can't access other web pages except the navigation page display
- C + + how to do this program
- Want to know how to find the parameters of this function? How should the matlab code knock
- Multi module project cannot inject mapper java
- MapReduce average score how to find the average of each line
- Wechat applet rendering layer error
- What does this mean? Why can't I open my QQ
- CMD run Py file encountered a problem
- Help me see what's wrong
- Why not 13bingo
- Decipher the password and there is no result after running?
- Ask you why this code can't run (◞‸◟)
- Hello, can you extract the of our applet
- Why not show folders when attaching a database
- How can the last line end with 0 without spaces