Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 15107 Views
- I also Faced
- E-Mail Answers
Answer Posted / meher.shareen
begin
update emp set sal=sal+1000
where deptno=10;
update emp set sal=sal+2000
where deptno=20;
update emp set sal=sal+3000
where deptno=30;
update emp set sal=sal+4000
where deptno=40;
end;
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Can I learn sql in a week?
Can we alter stored procedure?
Why should I use postgresql?
How is sql used in oracle?
What is the sql query to display the current date?
Why functions are used in sql?
What is scope and visibility in PL/SQL?
Advantages and disadvantages of stored procedure?
What is assignment operator in pl sql?
What is procedure in pl sql?
How many triggers can be applied to a table?
Explain aggregate functions are available there in sql?
What is view explain with example?
How many types of cursors are available in pl/sql?
What are the two types of periodical indexes?
