Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 15208 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
Which are the different character-manipulation functions in sql?
How many types of privileges are available in sql?
How do I enable sql encryption?
define sql insert statement ? : Sql dba
How does postgresql compare to oracle/db2/ms sql server/informix?
What is sqlerrm?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is self-join and what is the requirement of self-join?
How do you delete data from a table?
Explain what is a database?
How to get help at the sql prompt?
How much does sql certification cost?
How will you distinguish a global variable with a local variable in pl/sql?
Is natural join and inner join same?
What is a pl/sql block?
