MySQL Forums
Forum List  »  Oracle

link between oracle and mysql
Posted by: suresh kumar
Date: April 07, 2017 05:48PM

SQL> select * from bike @link1;

mno bname count
---------- ---------- ----------
duke ktm 6
apache tvs 29
activa honda 24
fz-16 yamaha 16

SQL> select mno from bike;

MNO
----------
duke
apache
activa
fz-16

SQL> select mno from rsk.bike @link1;
select mno from rsk.bike @link1
*
ERROR at line 1:
ORA-00904: "MNO": invalid identifier


i have created a link for mysql in my oracle but i can select all the rows
you can see that on the above code then why cann't access the single row from
mysql. And also i can't update the specific value in mysql via oracle using link

Options: ReplyQuote


Subject
Views
Written By
Posted
link between oracle and mysql
1078
April 07, 2017 05:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.