Update sql query in oracle

Connect and share knowledge within a single location that is structured and easy to search. I need to update newly created column in my oracle table.

To do so I need to use existing values in row to decide how to populate this column, I am getting error:. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Update query if statement for Oracle Ask Question. Asked 6 years, 11 months ago. Active 6 years, 11 months ago. Viewed 27k times. To do so I need to use existing values in row to decide how to populate this column, I am getting error: java. Improve this question. Lalit Kumar B Jakub Zak Jakub Zak 1, 6 6 gold badges 28 28 silver badges 52 52 bronze badges.

Add a comment. Active Oldest Votes. Improve this answer. It must be the name of a column in the referenced table or view. You can retrieve the column values into variables or host variables, or into collections or host arrays. The old column values are used on the right side of the equal sign. The subquery must return exactly one row and one column. The subquery must return exactly one row that includes all the columns listed.

The column values returned by the subquery are assigned to the columns in the column list in order. The first value is assigned to the first column in the list, the second value is assigned to the second column in the list, and so on.