fetch out of sequence 2004-08-23 - By Paula_Stankus@(protected)
Rewriting into an update - I am testing a multiple column - join update:
1 update
2 (select a.last_name, b.last_name
3 from emp a, person b
4 where a.emp_id =3D b.person_id)
5* set a.last_name =3D b.last_name
SQL > desc person;
Name Null? Type
-- ---- ---- ---- ---- ---- ---- ---- --- -- ----- =
-- ---- ---- ---- ---- -----
PERSON_ID NUMBER
LAST_NAME VARCHAR2(50)
FIRST_NAME VARCHAR2(50)
LOADDATE DATE
SQL > desc emp;
Name Null? Type
-- ---- ---- ---- ---- ---- ---- ---- --- -- ----- =
-- ---- ---- ---- ---- -----
EMP_ID NUMBER(38)
LAST_NAME VARCHAR2(50)
FIRST_NAME VARCHAR2(50)
LOADDATE DATE
When I execute the above update, I get the error:
set a.last_name =3D b.last_name
*
ERROR at line 5:
ORA-00904 (See ORA-00904.ora-code.com): "B ". "LAST_NAME ": invalid identifier
What am I doing wrong?
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
