UPDATE ORD
SET COMMPLAN='D'
WHERE COMMPLAN='' ;


DELETE FROM ORD
WHERE ORDID=620 AND TOTAL>450;

ALTER TABLE CUSTOMER
ADD STATUS CHAR;


ALTER TABLE CUSTOMER
ALTER COLUMN STATUS CHAR (15);

ALTER TABLE CUSTOMER
DROP COLUMN STATE;

ALTER TABLE PRODUCT
ALTER COLUMN DESCRIP CHAR (50);

UPDATE EMP
SET JOB='SENIOR MANAGER'
WHERE JOB='MANAGER' AND HIREDATE<'1-JUN-81'  AND SAL>2900;

ALTER TABLE EMP
ALTER COLUMN JOB CHAR (15);

UPDATE ORD
SET SHIPDATE='1-JAN-88'
WHERE TOTAL=10 AND ORDERDATE>'31-JAN-86';