错误: ORA-00907:缺少oracle的右括号

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
WHERE id > 100;

CREATE VIEW my_view AS
SELECT id, name
FROM my_table
WHERE id > 100;

CREATE INDEX my_index ON my_table (id;

CREATE INDEX my_index ON my_table (id);