sql - Oracle DDL 错误 - ORA 00907:缺少右括号
问题描述
这个 DDL 查询不起作用,我不知道为什么,希望有经验的人提供帮助:)
当我尝试在 Oracle 中运行它时,它返回错误消息 ORA-00907:缺少右括号
CREATE TABLE "Attendees" (
"attendee_id" number(8) PRIMARY KEY,
"attendee_name" varchar2(50),
"attendee_class" number(4),
"attendee_school" varchar2(50),
"attendee_status" varchar2(50)
);
CREATE TABLE "History" (
"history_id" number(4) PRIMARY KEY,
"history_dt" date,
"history_time" timestamp,
"history_status" varchar2(50)
);
CREATE TABLE "Event" (
"event_id" number(10) PRIMARY KEY,
"event_name" varchar2(200),
"event_location" varchar2(100),
"event_size" number(4),
"start_dt" date,
"end_dt" date,
"class_restriction" number(4),
"school_restriction" varchar2(100),
---"booking_id" number(10) references Booking(booking_id)
--- "reservation_id" number(3) references Reservation(reservation_id)
);
CREATE TABLE "Booking" (
"booking_id" number(4) PRIMARY KEY,
"booking_date" date,
"booking_cost" number(8),
"booking_status" varchar2(50),
"history_id" number(4) references History(history_id),
"event_id" number(10) references Event(event_id)
);
CREATE TABLE "Reservation" (
"reservation_id" number(3) PRIMARY KEY,
"event_id" references Event(event_id),
"attendee_id" references Attendees(attendee_id),
"reservation_status" varchar2(50)
);
解决方案
推荐阅读
- php - 仪表板索引页四个错误,但本地主机工作良好
- python - 如何从 python 脚本打开 .cmd 文件
- mysql - SQL - 多个表 - 始终返回数据或 null
- python - 具有多个元信息的时间序列预测 (GRU)
- android - 改进来自 Tensorflow 的对象检测演示中的相机预览
- python - 如何在 queue.get() 中确定队列项来自哪个线程——python
- regex - Logstash 过滤器,如果字段匹配正则表达式不起作用
- javascript - 使用属性更新对象属性中的数组
- mysql - MYSQL - MATCH AGAINST 得分值 = 0 但在 WHERE 子句中 > 0
- javascript - jQuery计数器并添加一个类但不是前两个?