fetch out of sequence 2004-08-23 - By Anthony Molinaro
The syntax is fine, it 's just that a and b no longer exist outside the
parenthesis.
update (
select a.last_name a_last_name, b.last_name b_last_name
from emp a, person b
where a.emp_id=3Db.person_id
)
set a_last_name=3Db_last_name;
- ant
-- --Original Message-- --
From: Gogala, Mladen [mailto:Mladen.Gogala@(protected)]=20
Sent: Monday, August 23, 2004 1:35 PM
To: 'oracle-l@(protected) '
Subject: RE: fetch out of sequence
Completely incorrect syntax. You cannot update a column=20
|
|
