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

How does cross join work in sql?

529

What is self-join and what is the requirement of self-join?

628

Can we use views in stored procedure?

508

How do you add a column to a table?

594

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

599

How can you know that statistics should be updated?

600

What are synonyms in sql?

532

What is the advantage of index in sql?

535

Is sqlexception checked or unchecked?

535

what are local and global variables and their differences? : Sql dba

531

what is dbms? : Sql dba

541

How do you create an update query?

517

The in operator may be used if you know the exact value you want to return for at least one of the columns.

554

What operating systems are supported by oracle sql developer?

518

How do you sort in sql?

597