SQL> @fiveQueries.sql

CUSTNAME ENROLLDAT

------------------------------ ---------

John B. Smith 08-DEC-55

CUSTNAME PLANS

------------------------------ ----------

John B. Smith 4

Joyce English 3

Ramesh K. Narayan 2

Table created.

CUSTNAME

------------------------------

Ahmad V. Jabbar

John B. Smith

LEVEL1

----------

45

50

80

1 row updated.

LEVEL1

----------

40

50

80

CUSTNO MODELTYPE

--------------- ----------

20031001SMI001 1

20031015ZEL001 1

20031023NAR001 1

20031031ENG001 1

2 rows created.

CUSTNO MODELTYPE

--------------- ----------

20031001SMI001 1

20031015ZEL001 1

20031023NAR001 1

20031031ENG001 1

20030917JAB001 1

20031001SMI002 1

6 rows selected.

View created.

CUSTNAME ZIPIN ST LEVEL1 LEVEL2 LEVEL3

------------------------------ ---------- -- ---------- ---------- ----------

John B. Smith 922 CA 80 80 50

Ramesh K. Narayan 922 CA 80 80 50

Joyce English 922 CA 80 80 50

Alicia J. Zelaya 949 MI 80 80 50

SQL>