CREATE TABLE AAAAAAAAAA ( supplier_id numeric(10) not null, supplier_name varchar2(50) not null, contact_name varchar2(50), CONSTRAINT supplier_pk PRIMARY KEY (supplier_id) ) ;

INSERT INTO AAAAAAAAAA (supplier_id, supplier_name) VALUES (1, 'OK') ;

COMMIT ;

CREATE TABLE ABAAAAAAAA ( product_id numeric(10) not null, supplier_id numeric(10) not null, CONSTRAINT fk_supplier FOREIGN KEY (supplier_id) REFERENCES AAAAAAAAAA(supplier_id) ) ;


INSERT INTO ABAAAAAAAA (product_id, supplier_id) VALUES (1, 1) ;

COMMIT ;

EXIT ;