Case statements in Oracle

-- Create Table

Create Table hkb_test3

(

User_id number (4 ),

Age number (4 ),

User_number number (4)

)

SQL> select * From hkb_test3;

 

User_id age user_number

-----------------------

1 12

2 14

3 16

4 11

Example:

Update hkb_test3

Set user_number = (select B. user_number

From (select a. user_id,

Case

When a. Age = 12 then

'6'

When a. Age = 14 then

'7'

When a. Age = 16 then

'8'

Else

'9'

End user_number

From hkb_test3 A) B

Where B. user_id = hkb_test3.user_id );

SQL> commit;

 

Commit complete

SQL> select * From hkb_test3;


user_id age user_number

------- ----- -----------

1 12 6

2 14 7

3 16 9

4 11 9