DROP TABLE account;
CREATE TABLE account (name varchar2(20), address varchar2(20), id number, amount number);
INSERT INTO account VALUES ('Bob Dugan', 'Wayland, MA 01778', 42, 10000);
INSERT INTO account VALUES ('Mike Dugan', 'Seattle, WA 98072', 39, 20000);
INSERT INTO account VALUES ('Tim Dugan', 'Houston, TX 00352', 41, 30000);
INSERT INTO account VALUES ('Kathleen Dugan', 'Orlando, FL 01345', 39, 40000);
COMMIT;
