1. In Oracle, create a CUSTOMERS table with the following fields. (You may use v
ID: 3713774 • Letter: 1
Question
1. In Oracle, create a CUSTOMERS table with the following fields. (You may use varchar2 if you like ) SQL> describe customers Name Null? Type SSN LASTNAME FIRSTNME MIDDLE PHONE CHAR (9) CHAR (30) CHAR (30) CHAR (30) CHAR (10) 2. Write a program hw7.sql that will insert a new customer record into the table, like the following SQL> start a :hw7 -- New Customer Program -- Please enter the customer'3 SOCIAL SECURITY NUMBER: 837465538 Please enter the customer'3 LAST NAME koch Please enter the customer's FIRST NAME: george please enter the customer' 3 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.Explanation / Answer
CREATE table Customers(SSN Char(9),LastName char(30),
firstname char(30), middle char(30), phone char(10))
INSERT into Customers VALUES('837465538','kich','george','will',
'5629851111');
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.