HOW TO UPDATE CURRENT ROW Comparing it with Existing Value.. [message #590094] |
Sun, 14 July 2013 21:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/6d6ee9000ee57dcf6a0e98bfa70849cf?s=64&d=mm&r=g) |
D_ORA
Messages: 32 Registered: November 2012 Location: UK
|
Member |
|
|
I have master-detail form I would like to update the emp1 table on the base of current value of dept table deptno and emp table ename .
update emp1
set ename = :emp.ename
where ename =
(select ename from emp e
where e.ename=:emp.ename
and e.deptno=:dept.deptno);
I try the above query but it did not able to update emp1 table.
Any advice will be appreciated...
[Updated on: Sun, 14 July 2013 21:15] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|