Home » RDBMS Server » Networking and Gateways » Re: Please help, Oracle Error TNS -12535 !
Re: Please help, Oracle Error TNS -12535 ! [message #66185] Mon, 14 January 2002 08:25
RP
Messages: 8
Registered: January 2000
Junior Member
SQL> /*-----------------------------------*/
SQL>
SQL>
SQL> --Query 6 self join
SQL> SELECT c.ear_tag_number, c.cow_name, m.ear_tag_number, m.cow_name
2 FROM Cows c, Cows m
3 WHERE c.ear_tag_number = m.cow_name;
WHERE c.ear_tag_number = m.cow_name
*
ERROR at line 3:
ORA-01722: invalid number

alias not working pls help
Previous Topic: Oracle not available
Next Topic: Re: 12547 error using bequeath adaptor from sqlplus
Goto Forum:
  


Current Time: Fri Apr 19 16:53:14 CDT 2024