MySQL Forums
Forum List  »  General

Re: oralce hierarchy query to mysql
Posted by: Rick James
Date: October 29, 2014 11:08AM

That's an example of why it is futile to try to write SQL that works across multiple vendors.

Functions: Decode, nv12, to_char, to_number, etc do not exist

(+)= needs to be LEFT JOIN (or RIGHT JOIN?)

IN ( SELECT ... ) is grossly inefficient in MySQL.

Don't convert dates to strings before comparing them. I am assuming you are using DATE, DATETIME, or TIMESTAMP datatypes. If not, you should be.

Etc.

Options: ReplyQuote


Subject
Written By
Posted
October 29, 2014 06:31AM
Re: oralce hierarchy query to mysql
October 29, 2014 11:08AM


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.