DBST 651 (Formerly CSMN 661) Sample Scripts:

Retrieve Data

SPOOL RETRIEVE_INFO

SELECT * FROM CUSTOMER;

SELECT FIRST_NAME, MIDDLE_INT, LAST_NAME FROM CUSTOMER;

SELECT LAST_NAME, CHECKING_TOTAL FROM CUSTOMER WHERE ACCOUNT_NUMBER>5555555555;

SELECT * FROM CUSTOMER WHERE LAST_NAME='SMITH';

SELECT * FROM CUSTOMER C, NOTE N WHERE C.ACCOUNT_NUMBER=N.ACCOUNT_NUMBER
AND C.LAST_NAME='SMITH';

SELECT * FROM CUSTOMER ORDER BY LAST_NAME;

SELECT COUNT(*) FROM CUSTOMER;

SPOOL OFF