Homework $8.$ Oracle Programming $1$

Due $q,$

In Oracle, create a hw$8\_$Customers table with the following fields. $($You may use varchar$2$ if you like $(2))$

SQL$>$ describe hw$8\_$customers;

Name

Null? Type

$q,----$

SSN

CHAR $(9)$

LASTNAME

CHAR $(30)$

FIRSTNAME

CHAR $(30)$

MIDDLE

CHAR $(30)$

PHONE

CHAR $(10)$

$2.$ Write a program hw$8.$sql that will insert a new customer record into the table, like the following:qquad

Specifications:

The system displays the New Customer Program title.

The system prompts for social security number, last name, first name, middle name, and phone of the new customer. Notice that the user can enter in lower case.

The system inserts the new record into the hw$8\_$Customers table.

The system displays the new record $($from the hw$8\_$Customers table$)$ for confirmation. Note that $(1)$ data should be displayed with appropriate format. $(2)$ there are OTHER customer data in the hw$8\_$Customers table. You should only display the current customer.

Spool your output to hw$8.$txt$.$ Run the program until there is no error. Test your program by entering at least $2$ customers $($so I can see your query pulls up the correct record$).$ Print a copy of hw$8.$sql and hw$8.$txt$.$ Turn in both copies.