ECET 450: Laboratory 3

School: Academy of Healing Arts Massage and Facial Skin Care           Price: $15.00 USD

Document Description


Purpose:
This laboratory provides practice in the creation and use of basic and advanced SQL queries involving one table in a DB schema.
Procedure:
Using your assigned user name, password, and host string, log in to Oracle SQL*Plus, and open a spool file to collect your dialog. Create queries to answer the following questions. Your queries should be written so that they use only the data provided and display only the data requested.
Don’t edit the initial spool file. You will make mistakes and will not be penalized for them. Attach it to the back of your report. Follow the instructor’s instruction concerning any additional required items, any needed sign-offs, and the due date of this report.
Part A:
1. Display the ids and names for all customers.

select cust_id, cust_name from customer;

2. Display all the data in the sales representative table.

select * from rep;

3. Display the names of all customers whose credit limits are $10,000

Written By

Studypool Tutor
Academy of Healing Arts Massage and Facial Skin Care
ECET 450: Laboratory 3Purpose:This laboratory provides practice in the creation and use of basic and advanced SQL queriesinvolving one table in a DB schema.Procedure:Using your assigned user name, password, and host string, log in to Oracle SQL*Plus, and opena spool file to collect your dialog. Create queries to answer the following questions. Yourqueries should be written so that they use only the data provided and display only the datarequested.Dont edit the initial spool file.You will make mistakes and will not be penalized for them.Attach it to the back of your report. Follow the instructors instruction concerning any additionalrequired items, any needed sign-offs, and the due date of this report.Part A:1.Display the ids and names for all customers.2.Display all the data in the sales representative table.ANSWER: SELECT * FROM REP ;3.Display the names of all customers whose credit limits are $10,000 or more.ANSWER:SELECT CUST_NAME FROM CUSTOMER WHERE CUST_LIMIT>=$10,000;ECET 450Laboratory 3Page 1 of 64.Display the invoice number for allorders placed by the customer whose id is 1619 onSeptember 13, 2007. Please note: A date in a condition should be in the form 13-SEP07.ANSWER: SELECT INVOICE_NUM FROM INVOICE WHERE CUST_ID=1619 ANDINVOICE_DATE = 09/13/2007 ;5.Display the id and the name for all customers whose sales representativehas an id ofeither237 or 268.ANSWER:SELECT CUST_ID, CUST_NAME FROM CUSTOMER WHER
lock_open Buy Document

Reviews from Students

Studypool Student
"Very Satisfied."
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1828 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors