MySQL Forums
Forum List  »  General

MySQL/Oracle Relations
Posted by: Shane Osaki
Date: March 24, 2005 12:39PM

I currently have a MySQL database with contact information. There is another Oracle database which stores individual id numbers of the contacts I have in my MySQL database.

I would like to link the Oracle data to the MySQL data, but how would I do that with relations?

For instance, here is some sample data:

(Name SS# ID#)
Bob 2 10000
Jane 8 12035
Kelly 1 56435
Keith 10 45231

What I would like to do is relate each unique Oracle id number, to each unique SS#. Does anyone know how I would be able to accomplish this without manually entering each data item?

Options: ReplyQuote


Subject
Written By
Posted
MySQL/Oracle Relations
March 24, 2005 12:39PM


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.