Question: In Oracle, using SQL+. I'm having trouble writing the proper insert statement that comes after the accept statement. 1. In Oracle, create a CUSTOMERS table

In Oracle, using SQL+. I'm having trouble writing the proper insert statement that comes after the accept statement.

In Oracle, using SQL+. I'm having trouble writing the proper insert statement

1. In Oracle, create a CUSTOMERS table with the following fields. (You may use varchar2 if you like) SoL> describe customers Null? Type CHAR (9) CHAR (30) CHAR (30) CHAR (30) CHAR (10) SSN varchar2 FIRSTNAME MIDDLE PHONE 2. Write a program hw7. sql that will insert a new customer record into the table, like the following: SoL> start a:hw7 New Customer Program- Please enter the customer 's SOCIAL SECURITY NUMBER: 837465538 Please enter the customer 's LAST NAME: koch Please enter the customer 's FIRST NAME: george please enter the customer 's MIDDLE NAME: will Please enter the customer' s PHONE: 5629851111 *-The following record has been updated: Social Security Number 837-46-5538 Name: Koch, George W Phone: (562) 985-1111 Specifications: 1. The system skips 1 line and displays the New Customer Program title. 2. 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 3. The system inserts the new record into the CUSTOMERS table. 4. The system displays the new record (from the CUSTOMERS table) for confirmation. Note that the data should be displayed with appropriate format. Spool your output to hw7.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 hw7.sql and hw7.txt. Turn in both copies

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!