Mysql table design, considering possible migration to oracle, how to design field types is more convenient for later migration

  mysql, question

For example, can datetime and tinyint on mysql be smoothly migrated to other oracle data types, such as date and number

In oracle used in the recently contacted projects, the following sentence should be added to every query insertion of date: “alter session setnls _ date _ format =’ yyy-mm-ddhh24: mi: ss'”; In addition, INTEGER, NUMBER, VARCHAR2 are commonly used, hoping to be helpful to you.