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
15211 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 dml with example?

1094

How does a trigger work?

1077

what is foreign key? : Sql dba

1063

How many aggregate functions are available there in sql?

988

Why do we use sql constraints?

1176

Is sql a scripting language?

1023

Explain what is rdbms?

1045

explain the difference between bool, tinyint and bit. : Sql dba

1011

what is the use of double ampersand (&&) in sql queries?

1178

What are tables in sql?

1072

What are the types of keys?

999

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1583

What are the built in functions of sql?

1032

What is denormalization in a database?

1060

Explain the working of foreign key?

1072