Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
PL/SQL and SQL
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Mar 23, 2013 8:31 PM by
How to use CASE in an update ?
Mar 23, 2013 8:30 PM
I did so and an error happened:
UPDATE TB_FUNCIONARIO SET NIVEL =
CASE WHEN CARGO = 'PROGRAMADOR' AND SALARIO BETWEEN 4000 AND 8000 THEN 'PLENO'
WHEN CARGO = 'PROGRAMADOR' AND SALARIO <= 2000 THEN 'JUNIOR'
ELSE 'SENIOR' END
how to solve ?
Edited by: 995757 on 23/03/2013 13:29
This content has been marked as final.
Show 1 reply
Re: How to use CASE in an update ?
Mar 23, 2013 8:31 PM
in response to