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 a foreign key ? : Sql dba

1117

What is pl/sql language case sensitive?

1182

Explain scalar functions in sql?

1105

List and explain the different types of join clauses supported in ansi-standard sql?

1409

What is sql dialect?

1181

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1021

What is the purpose of the sql select top clause?

1208

What is difference between group by and partition by?

1129

Can we create foreign key without primary key?

1040

How do I view tables in sql developer?

1009

How to find 3rd highest salary of an employee from the employee table in sql?

1133

what is csv? : Sql dba

1051

Explain polymorphism in pl/sql.

1171

What is information schema in sql?

1119

Does db2 use sql?

1009