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 many sql ddl commands are supported by 'mysql'? : Sql dba

1000

How to convert comma separated string to array in pl/sql?

1164

What does partition by mean in sql?

942

What is set serveroutput on in pl sql?

1271

What is number function in sql?

943

Is ms sql traffic encrypted?

909

Explain the difference between drop and truncate commands in sql?

1020

How do I run pl sql in sql developer?

1099

Is delete faster than truncate?

993

What is the usage of the distinct keyword?

1198

How to sort the rows in sql.

1049

What is the most restrictive isolation level? : Transact sql

1068

Is it possible for a table to have more than one foreign key?

1016

What are string functions in sql?

1219

Is sql between inclusive?

1108