UPDATE employees SET salary=DECODE(department

How to update salary of employees department wise?

Question Posted / k v koteswara rao

Answer Posted / k v koteswara rao

UPDATE employees SET salary=DECODE(department_id,10,salary+1000,20,salary+2000,30, salary+3000,salary);

Is This Answer Correct ?

18 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How delete all data from table in sql?

1003

is it possible to pass an object or table to a procedure as an argument?

1105

How do you use collections in procedure to return the resultset?

2228

Does varchar need length?

978

How can you load microsoft excel data into oracle? : aql loader

1155

What does data normalization mean?

941

What is an implicit commit?

1038

Can we use distinct and group by together?

1025

Why do we use joins in sql?

956

What are all the different normalizations?

1020

how to shutdown mysql server? : Sql dba

1081

what is msql? : Sql dba

969

Explain architecture of sql server notification services?

1038

What is a call statement? Explain with an example.

990

what are date and time functions in mysql? : Sql dba

963