How to update salary of employees department wise?

Answer Posted / prativa mishra

update employees
set salary=salary+1000
where department_id=&department_id

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you sum a count in sql?

560


Will truncate release space?

518


What are basic techniques of indexing?

848


How do you modify a column in sql?

536


what is cross join? : Sql dba

576






Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

666


What is sql partition function?

619


How to change sql*plus system settings?

544


what is a constraint? Tell me about its various levels. : Sql dba

564


What is sql comments?

651


What is the difference between a primary key and a clustered index?

526


Which data dictionary views have the information on the triggers that are available in the database?

756


What is rename command in sql?

467


What is a Mapplet?

645


How do you use a while loop in pl sql?

539