Update statement in SET clause subquery is allowed or not?

Questions by ddkdhar   answers by ddkdhar

Showing Answers 1 - 2 of 2 Answers

Nikhil_4_Oracle

  • Mar 8th, 2007
 


HI ALL,

update statement in SET clause subquery is allowed ,

Try this ,

update emp set sal=(select sal from emp where empno=7900)

where deptno=20

Bye,

Nikhil.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions