ORA-00907:突触中缺少右括号

CREATE TABLE my_table (
    id INT,
    name VARCHAR(50)
-- 缺少右括号

CREATE TABLE my_table (
    id INT,
    name VARCHAR(50)
) -- 添加右括号

CREATE VIEW my_view AS
SELECT id, name
FROM my_table
-- 缺少右括号

CREATE VIEW my_view AS
SELECT id, name
FROM my_table
-- 添加右括号

CREATE TRIGGER my_trigger
BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
    -- 触发器逻辑
-- 缺少右括号

CREATE TRIGGER my_trigger
BEFORE INSERT ON my_table
FOR EACH ROW
BEGIN
    -- 触发器逻辑
END; -- 添加右括号