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

6 Answers
14930 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is embedded sql in db2?

955

How to write a query to show the details of a student from students table whose

936

What are different methods to trace the pl/sql code?

1046

What is a record in pl/sql?

1069

What is pl sql variable?

935

difference between anonymous blocks and sub-programs.

1079

Explain about various levels of constraint.

883

How to run sql statements with oracle sql developer?

998

What are some predefined exceptions in pl/sql?

1062

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1785

what is a cursor? : Sql dba

972

define data blocks ? : Sql dba

929

what are different types of collation sensitivity? : Sql dba

1021

How can you view the errors encountered in a trigger?

915

How can a function retun more than one value in oracle with proper example?

1025