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';