Hi,
I have to integrate an existent Oracle database with a MySQL database. The problem is that part of the information that I need to show on the website is on the Oracle database (personal info) and the remaining info is on the MySQL database. Now what I would like to do is to create some kind of a view on the MySQL database to a table on the Oracle database in order to perform complex queries. This may sound a little crazy, but is it possible?
Kevin
Not really. Unlessthe mysql database engine can execute queries on an oracle database.... not very likely is it? :-)
I think you'll have to do it in PHP, probably by creating some new tables in oracle or in mysql.