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 use case expression? : Sql dba

559

What are the types of keys?

518

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

814

What is sql entity?

538

How can you load multi line records? : aql loader

666

Explain the difference between sql and mysql.

573

what is clause? : Sql dba

602

What is acid property in a database?

589

Why is sql better than hql?

514

What is a variable in sql?

520

what is text? : Sql dba

569

what is a relationship and what are they? : Sql dba

559

How do I view stored procedures?

552

What trigger means?

571

How do I install sql?

527