FIT
100
Basic Data Management
v
Checking the Table Contents
o
SELECT <attribute names> FROM <table names>;
o
Examples:
;
SELECT * FROM PRODUCT;
;
;
SELECT P_CODE, P_DESCRIPT, P_INDATE, P_ONHAND,
P_MIN, P-PRICE, P_DISCOUNT, V_CODE
FROM PRODUCT;
The Product Table’s First Two Rows