Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
converting update sql to oracle
- Thread starter Nordyck
- Start date
Broadly, the syntax is:
I can't however comment on whether the update makes much sense. The condition "e.NHACEI = e.CEI" looks pretty suspicious.
For Oracle-related work, contact me through Linked-In.
Code:
Update G081_ELTNHA e
set e.NHAPN =
(select e1.PN
from G081_ELTNHA e1
where e.NHACEI = e.CEI and e.NHASN = e1.SN )I can't however comment on whether the update makes much sense. The condition "e.NHACEI = e.CEI" looks pretty suspicious.
For Oracle-related work, contact me through Linked-In.
- Status
Similar threads
