RE: fetch out of sequence

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Mon, 23 Aug 2004 13:30:32 -0400
Message-ID: <80D4A99A2715674EB2D256DAD89219F6044E8C70@dohsmail02.doh.ad.state.fl.us>

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: "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_at_freelists.org 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


-----------------------------------------------------------------

Received on Mon Aug 23 2004 - 12:26:15 CDT