begin updata emp set sal=sal+1000 where deptno in(10,20,30,40); end;

How to update salary of employees department wise?

Question Posted / 8008064637

Answer Posted / 8008064637

begin
updata emp set sal=sal+1000 where deptno in(10,20,30,40);
end;

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the difference between alter trigger and drop trigger statements?

602

What is the difference between mdf and ndf files?

573

Why does sql need a server?

564

What is hibernate and its relation to sql?

594

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6086

What are actual parameters and formal parameters?

570

What is a sql instance vs database?

578

What are the various levels of constraints?

666

What is the usage of sql functions?

547

What operating systems are supported by oracle sql developer?

520

Is clustered index a primary key?

537

what is a unique key ? : Sql dba

547

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1644

Does truncate remove indexes?

563

Explain what is sql*plus?

670