Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 14927 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
What is use of package in pl sql?
What is the difference between joins?
Is sql easier than java?
How do you update sql?
What is denormalization in a database?
Can a foreign key be null?
What sql database should I use?
How do I write a sql query in pgadmin 4?
Explain polymorphism in pl/sql.
What is faster join or subquery?
what is a constraint? : Sql dba
What operating systems are supported by oracle sql developer?
What jobs use sql?
how is exception handling handled in mysql? : Sql dba
How do I start sql profiler?
