首页 > 解决方案 > 为什么无法创建此表?SP2-0042

问题描述

为什么我不能创建这个?我不断收到错误 sp2-0042: unknown command ")"

 create table orders
    (
    onum number(4),
    vnum number(4),
    knum number(4),
    bedrag number(8),
    odatum date,
    constraint pk_order PRIMARY KEY (onum),
    constraint fk_order_verk FOREIGN KEY (vnum) references verkopers(vnum),
    constraint fk_order_knum FOREIGN KEY (knum) references klanten(knum),
    constraint ch_bedrag check ( bedrag > 0),
    constraint ch_date check ( odatum < sysdate OR odatum = sysdate)
    );

标签: sqloracleconstraints

解决方案


推荐阅读