Case plsql update

One more thing is that here we update only a single column. By using the above statement, we updated two columns because, in my table, there are two columns, but in your case, we updated more than two columns.

First, we need to create the new table by using the create table statement as follows. By using the above statement, we created a new table that deptB as shown, and we insert some records into the deptB. In the above example, we updated records from another table, where we need to update studentA table from the deptB table, so that is why we need to build some relation between these two tables.

That means we need a common column in both tables then, and then we can perform the update. From the above article, we have learned the basic syntax of updates, and we also see different examples of updates. Examples and code implementation. You may also have a look at the following articles to learn more —. If budgpost is really a character column as is stated, then we have to assume that a non-numeric value might make its way into one of the In clauses.

Thomas: It's not uncommon for a DBA to have no control over the arguments passed by clients. In this case the client might pass ,, or something. Not sure, the question can be interpreted either way. Andomar - But then how would they fix the Case expression? If they can change the Case expression, then they should be able to correct the values passed to the Case expression even if they cannot change which values are passed to it.

Andomar - Said another way, if I'm only able to correct the procedure which is passed an argument with values like 1,2,3. I can't change what I get passed, but I can take what I'm given and change it to '1','2','3'. Show 4 more comments. Andomar Andomar k 44 44 gold badges silver badges bronze badges. If you can change the in string, use Thomas' answer — Andomar. Gary Myers Gary Myers SriniV This query is overly complex and hard to understand.

Looks like you're making Oracle process string inputs inside a shell script. You should process the inputs before plugging them into the SQL. That would simplify the query — roblogic. Scott Scott 4 4 silver badges 7 7 bronze badges. Answer: Yes, below is an example of a case statement that evaluates two different fields. While using this site, you agree to have read and accepted our Terms of Service and Privacy Policy. Please re-enable javascript in your browser settings.

It is the value that you are comparing to the list of conditions. Sagar Shinde Updated date Dec 20, I have SQL server Table in which there is column that I wanted to update according to a existing column value that is present in current row.

The CASE expression has two formats,. The simple CASE expression compares an expression to a set of simple expressions to determine the result.