DBST 651 (Formerly CSMN 661) Sample Scripts:

Update Data

SPOOL UPDATE

INSERT INTO CUSTOMER VALUES (1234567900, 12345690, 'SUSAN', 'M', 'SMITH', '24 MAIN ST', 1000, 5000, '33333');

DELETE FROM CUSTOMER WHERE ACCOUNT_NUMBER=1234567900;

UPDATE CUSTOMER SET LAST_NAME='JOHNSEN' WHERE ACCOUNT_NUMBER=8888888888;

SPOOL OFF

Home

©2003-2004 by McGraw - Hill Companies, Inc. All rights reserved.