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

How to make a copy values from one column to another in sql?

576

What normalization means?

527

What is a record in pl/sql?

551

What is the current version of postgresql?

560

What is partition in sql query?

519

How to display Row Number with Records in Oracle SQL Plus?

594

How does pl sql work?

528

What is coalesce sql?

518

What is memory optimized?

557

What are sql data types?

548

Explain clause in sql?

564

List out the acid properties and explain?

563

How do I find duplicates in sql?

509

What is lexical units in pl sql?

573

What is flag in sql?

545