oracle创表缺少右括号createtableordertable(orderidnumberprimarykey,--订单编号usernamevarchar2(50)referenceusertable(username),totalPricenumerdefault0notnull,orderDatedatedefaultsysdatenotnull)createtableordertable(o

Question

oracle 创表缺少右括号
create table order_table(
order_id number primary key,--订单编号
username varchar2(50) reference user_table(username),
totalPrice numer default 0 not null,
orderDate date default sysdate not null
)
create table order_table(
order_id number primary key,--订单编号
username varchar2(50) reference user_table(username),
totalPrice number default 0 not null,
orderDate date default sysdate not null
)
这样的.

Answer 1

reference user_table(username) 把这句去掉,另外你的totalPrice的数据库类型不对,外键在创建表之后设置即可.