Home -> Usenet -> comp.databases.oracle -> RE:SQLPLUS

RE:SQLPLUS

From: bpanko <bpanko_at_podsun17.cc.binghamton.edu>
Date: 20 Jun 1994 13:44:39 -0400
Message-ID: <2u4ki7$233_at_podsun17.cc.binghamton.edu> 







Hi,everyone



I am new to this newsgroup and new to ORACLE .
I have this simple query in sqlplus



SQL>insert into subscrib(department_number)
2>  select department_number from deptmstr
3>  where subscrib.last_name=deptmstr.department_name;

                       *




 ERROR:ORA__00904: invalid column name



The explanation provided in ORACLE ERROR MESSAGES does not help my cause.
 NOTE:both last_name and department_name are defined char(20).



Thanks.
 
Received on Mon Jun 20 1994 - 19:44:39 CEST












Original text of this message