MySQL Forums
Forum List  »  Oracle

Advanced Search
New Topic

Re: Convert Oracle View to MySql
Posted by: hector vass
Date: August 23, 2009 05:28PM

First convert the SQL statement to work under MySQL
so this would mean ANSI style joins no Oracle joins like r.r_radio = e.r_radio(+) get rid of Oracle function like trunc(sysdate) .. might want to consider looking at how well it might perform so a good time to get rid of your NOT IN sub-query :)

Then pre-pend with create view myview as

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Convert Oracle View to MySql
6078
pravin vaidya
August 18, 2009 04:20AM
Re: Convert Oracle View to MySql
3027
hector vass
August 23, 2009 05:28PM


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.