Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

data type from Oracle to MySQL/MariaDB

hi,

I found this page:
 https://www.convert-in.com/docs/ora2sql/types-mapping.htm

is about what data type should we use once we migrate from Oracle to MariaDB.

any other reference you can suggest ? I convert using that tools from the link above and it is not fair to get that information from that company again.

any type convert for Oracle user define type ?
Avatar of Kent Olsen
Kent Olsen
Flag of United States of America image

As with any rule, take those conversions with a grain of salt.

Oracle likes to store numeric data in its own proprietary format.  Most DBMS defer numeric values to hardware supported data types.  

If you know that a column contains only integer values, use one of the INT types, not FLOAT or DOUBLE as the page suggests.
Avatar of marrowyung
marrowyung

ASKER

"If you know that a column contains only integer values, use one of the INT types"

good!

any UDT can have both number and char ?

any example of why developer do not use default type but UDT ?   one of the reason is they need a type easy to remember for their programming.
any idea to check the UDT in sql developer ?

I read this one :http://stevenfeuersteinonplsql.blogspot.com/2017/09/user-defined-types-in-oracle-plsql.html


and it seem it is a type to nest type of match the application needed?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.