Untitled

CREATE TABLE al1
(id NUMBER(7)
        CONSTRAINT al1_id_pk PRIMARY KEY,
        goods CHAR(25)
        CONSTRAINT al1_goods_nn NOT NULL,
        kind_goods CHAR(15),
        ord_id NUMBER(7)
        CONSTRAINT al1_ord_id_fk REFERENCES
        s_ord2 (id)
        CONSTRAINT al1_ord_id_nn NOT NULL,
        quantity NUMBER(4));

INSERT INTO al1(id, goods, kind_goods, ord_id, quantity)
VALUES (1,'bad', 'not bad', 97, 6);

INSERT INTO al1(id, goods, kind_goods, ord_id, quantity)
VALUES (2,'bad', 'not bad', 98, 4);

INSERT INTO al1(id, goods, kind_goods, ord_id, quantity)
VALUES (3,'bad', 'not bad', 98, 5);

INSERT INTO al1(id, goods, kind_goods, ord_id, quantity)
VALUES (4,'bad', 'not bad', 100, 7);

INSERT INTO al1(id, goods, kind_goods, ord_id, quantity)
VALUES (5,'bad', 'not bad', 101, 12) ;

UPDATE al1
SET goods='true'
WHERE quantity =12;

DELETE FROM al1
WHERE id=2;