mysql的脚本语句转oracle

以下是一个简单的Java方法，用于将MySQL的DDL转换为Oracle格式的DDL：

public static String convertMySQLToOracle(String mysqlDDL) {
    String oracleDDL = mysqlDDL.replaceAll("INT\\b", "NUMBER(11)")
                                .replaceAll("DATETIME\\b", "TIMESTAMP")
                                .replaceAll("AUTO_INCREMENT\\b", "GENERATED BY DEFAULT AS IDENTITY")
                                .replaceAll("ENGINE=InnoDB\\b", "")
                                .replaceAll("DEFAULT CHARSET=utf8mb4\\b", "");

    // Add Oracle specific keywords
    oracleDDL = "CREATE TABLE " + oracleDDL + "\n" +
                "LOGGING\n" +
                "PCTFREE 10\n" +
                "INITRANS 1\n" +
                "STORAGE (\n" +
                "  INITIAL 65536\n" +
                "  NEXT 1048576\n" +
                "  MINEXTENTS 1\n" +
                "  MAXEXTENTS UNLIMITED\n" +
                "  BUFFER_POOL DEFAULT\n" +
                ")\n" +
                "TABLESPACE USERS\n" +
                "NOPARALLEL;\n";

    return oracleDDL;
}

此方法将以下内容转换为Oracle格式：

• 将"INT"数据类型转换为"NUMBER(11)"
• 将"DATETIME"数据类型转换为"TIMESTAMP"
• 将"AUTO_INCREMENT"转换为"GENERATED BY DEFAULT AS IDENTITY"
• 从创建表语句中删除"InnoDB"引擎和"DEFAULT CHARSET=utf8mb4"选项
• 添加Oracle特定的关键字：LOGGING，PCTFREE，INITRANS，STORAGE，TABLESPACE，NOPARALLEL

使用该方法，您只需要将MySQL的DDL传递给它，然后它将返回等效的Oracle DDL。例如：

String mysqlDDL = "CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, created_at DATETIME NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
String oracleDDL = convertMySQLToOracle(mysqlDDL);
System.out.println(oracleDDL);

输出结果：

CREATE TABLE users (id NUMBER(11) GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, name VARCHAR(50) NOT NULL, created_at TIMESTAMP NOT NULL)
LOGGING
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536
  NEXT 1048576
  MINEXTENTS 1
  MAXEXTENTS UNLIMITED
  BUFFER_POOL DEFAULT
)
TABLESPACE USERS
NOPARALLEL;