Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Modeling And Relational Databases

Authors: Terry Halpin, Tony Morgan

2nd Edition

0123735688, 978-0123735683

More Books

Students also viewed these Databases questions

Question

l List and define several types of international employees.

Answered: 1 week ago