How to update salary of employees department wise?
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 |
Post New Answer View All Answers
what is a database? : Sql dba
What do you understand by pl/sql records?
How to write html code in pl sql?
What are the types of index in sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is trigger point?
Can we create view in stored procedure?
What does select count (*) mean in sql?
what is not null constraint? : Sql dba
Why commit is not used in triggers?
What is the difference between nested table and varray?
What is difference between joins and union?
What types of commands can be executed in sql*plus?
What is an ndf file?
How is sql used in oracle?