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 an exception in pl/sql?

725

Explain correlated query work?

792

What is your daily office routine?

1987

What is column?

723

Can we perform dml in function?

796

What is blind sql injection?

757

how to install mysql? : Sql dba

792

what is the difference between sql and t-sql? : Transact sql

811

What is the use of procedures?

716

How do you get column names only for a table (sql server)?

860

What is trigger with example?

739

What's the procedure?

665

what is a control file ? : Sql dba

759

What is Histogram?

1279

What is primary key and unique key?

763