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 database trigger and stored procedure?

1058

define join and explain different type of joins? : Sql dba

931

What is full form of rtm?

989

Can I join the same table twice?

1031

Why use truncate instead of delete?

988

What is sorting in sql?

926

how to check server status with 'mysqladmin'? : Sql dba

1051

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3035

how to calculate the difference between two dates? : Sql dba

1040

What are the different types of database management systems?

979

what is the syntax for using sql_variant_property? : Transact sql

1023

what is a trigger in mysql? : Sql dba

1128

Define tables and fields in a database

1111

What is pl sql record in oracle?

1010

What are the most important characteristics of pl/sql?

1134