HOW TO UPDATE CURRENT ROW Comparing it with Existing Value.. [message #590094] |
Sun, 14 July 2013 21:13 |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|