Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 15397 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 the command used to fetch first 5 characters of the string? : Sql dba
What is the purpose of the sql select top clause?
Is grant a ddl statement?
Why are cursors used?
What are sql built in functions?
What is the clause we need to add in function body to return variable?
What is the purpose of the partition table?
What is the benefit of foreign key?
What are the two parts of design view?
How many types of indexes are there in sql?
Is coalesce faster than isnull?
How can you load multi line records? : aql loader
What is mutating error in pl sql?
What is dml statement?
How to find 3rd highest salary of an employee from the employee table in sql?
