使用plsql编程为这张vip表o_id number N 主键 订单号g_id number N 外键引用goods表的g_id字段 商品号v_id number N 外键引用vip表的v_id字段 会员号o_address varchar2 收货地址o_count number 订单数量o_price number 价格o_date date 订单日期生成创建语句

CREATE TABLE vip_order ( o_id NUMBER PRIMARY KEY, g_id NUMBER, v_id NUMBER, o_address VARCHAR2(100), o_count NUMBER, o_price NUMBER, o_date DATE, CONSTRAINT fk_goods FOREIGN KEY (g_id) REFERENCES goods (g_id), CONSTRAINT fk_vip FOREIGN KEY (v_id) REFERENCES vip (v_id) );