How to update salary of employees department wise?

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

Why is nosql good?

777


What is rowid in sql?

676


What is use of term?

794


How to Declare Fixed Length String Value In PL SQL

843


What mean sql?

740






Where the sql database files are stored?

693


Can function return multiple values in sql?

735


Explain commit, rollback and savepoint.

766


What is dialect in sql?

703


what is the difference between sql and t-sql? : Transact sql

811


Why we use stored procedure instead of query?

710


How will you distinguish a global variable with a local variable in pl/sql?

844


what is rollback? : Sql dba

758


What is a schema? How is it useful in sql servers?

797


Does sql support programming?

769