Skip to content
Advertisement

how to use an if statement in update query in Oracle

I wanted to use if statement in Oracle update. Below is the condition that i wanted to achieve and i will not be able to use PL/SQL. I wanted to achieve the below result using update statement.

I tried the below update statement not exactly what i need but just trying a simple update using case..

Advertisement

Answer

Seems you want to use

desc is a reserved keyword. So, there cannot be a column name unquoted.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement