There are actually more things to consider when migrating from Oracle to MySQL than we need to sort out the technical details of data type conversion, but also more important.
There are two issues to consider in advance:
Why migrate from Oracle?
Why migrate to MySQL
If you answer the above two questions, you will basically straighten out the whole thing. I will explain it in a basic and objective manner.