Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 copiesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started