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 ?
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 ?
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.
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.
ASKER
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?
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 TRIALMembers 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.
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.