UPDATE EMP SET SAL=DECODE ( DEPTNO, 10, SAL+SAL*0.1, 20, SAL

How to update salary of employees department wise?

Question Posted / manoranjan sethy

Answer Posted / manoranjan sethy

UPDATE EMP
SET SAL=DECODE (
DEPTNO,
10, SAL+SAL*0.1,
20, SAL+SAL*0.2,
30, SAL+SAL*0.3,
40, SAL+SAL*0.4,
'NA'
)
/

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between explicit and implicit cursors in oracle?

1074

How does postgresql compare to oracle/db2/ms sql server/informix?

1042

Does user triggers have entry for trigger with compilation errors?

1045

Why do we use procedures?

964

Mention what are the benefits of pl/sql packages?

1090

What is a primary key called that is made up of more than one field?

1356

how to drop an existing view in mysql? : Sql dba

1068

What programs use sql?

1018

how to write date and time literals? : Sql dba

973

how to enter characters as hex numbers? : Sql dba

1050

Compare sql & pl/sql

1145

How does sql*loader handles newline characters in a record? : aql loader

1054

Does execute immediate commit?

1224

what is view? : Sql dba

978

Can we use delete in merge statement?

1049