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

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

INSERT INTO orders (o_id, g_id, v_id, o_address, o_count, o_price, o_date) VALUES (1, 1001, 2001, 'No.123, Main Street', 3, 99.9, TO_DATE('2022-05-01', 'YYYY-MM-DD'));