mysql脚本转化oracle

-- MySQL 分页查询
SELECT * FROM table_name LIMIT 10 OFFSET 20;

-- Oracle 分页查询
SELECT * FROM (
    SELECT a.*, ROWNUM rnum FROM (
        SELECT * FROM table_name
    ) a
    WHERE ROWNUM <= (20 + 10)
)
WHERE rnum > 20;

-- MySQL 数据类型
CREATE TABLE example (
    id INT PRIMARY KEY,
    created_at DATETIME
);

-- Oracle 数据类型
CREATE TABLE example (
    id NUMBER PRIMARY KEY,
    created_at TIMESTAMP
);

-- MySQL 字符串连接
SELECT CONCAT('Hello', ' ', 'World');

-- Oracle 字符串连接
SELECT 'Hello' || ' ' || 'World' FROM dual;

-- MySQL 存储过程
DELIMITER //
CREATE PROCEDURE example_procedure()
BEGIN
    SELECT * FROM table_name;
END //
DELIMITER ;

-- Oracle 存储过程
CREATE OR REPLACE PROCEDURE example_procedure AS
BEGIN
    SELECT * FROM table_name;
END;