oracle中触发器的问题

来源：百度知道 编辑：UC知道 时间：2024/07/01 07:58:23
--进货表
create table stock (
document_id varchar2(20),
ware_id varchar2(10),
counts number(10),
price number(10,2),
constraints sk_pk_id primary key(document_id, ware_id)
);
--库存表
create table storage (
ware_id varchar2(10),
counts number(10),
constraints sto_pk_id primary key(ware_id)
);
--单据表
create table document (
document_id varchar2(20),
stamp varchar2(20),
constraints doc_pk_id primary key(document_id)
);
--财务报表
create table affairs (
stamp varchar2(20),
amounts number(10, 2),
constraints aff_pk_stamp primary key(stamp)
);
alter table stock
add constraints sto_fk_d_id foreign key(document_id)
references document(document_id);
alter table stock
add constraints sto_fk_w_id foreign key(ware_id)
referen

CREATE TABLE WARE_STOCK (
VC_WARE_ID VARCHAR2(10),
VC_DOCUMENT_ID VARCHAR2(20),
VC_STOCK_UNIT_ID VARCHAR2(10) NOT NULL,
N_STOCK_COUNTS NUMBER(10) NOT NULL,
N_STOCK_PRICE NUMBER(10,2) NOT NULL,
N_STOCK_AMOUNT NUMBER(10,2),
D_STOCK_TIME DATE,
-- D_STOCK_TIME VARCHAR2(20),-- NOT NULL,
VC_STOCK_STORAGE_ID VARCHAR2(10) NOT NULL,
);

CREATE TABLE WARE_STORAGE (
VC_STORAGE_ID VARCHAR2(10),
VC_WARE_ID VARCHAR2(10),
N_STORAGE_COUNTS NUMBER(10),
N_WARNING_COUNTS NUMBER(10),
);

CREATE TABLE FINANCE (
VC_DOCUMENT_STAMP VARCHAR2(20),
N_BUSINESS_AMOUNT NUMBER(10,2),
);
CREATE TABLE DOCUMENT (
VC_DOCUMENT_ID VARCHAR2(20),
VC_DOCUMENT_STAMP VARCHAR2(20) NOT NULL,
N_DOCUMENT_AMOUNT NUMBER(10, 2)
);

CREATE OR REPLACE TRIGGER BI_WARE_