Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Modify the following sql command so that the rep_id

16/11/2021 Client: muhammad11 Deadline: 2 Day

ECET 450: Laboratory 5

Purpose:

This laboratory provides practice in the use of SQL commands to create simple reports in an Oracle database.

Procedure:

Using Oracle SQL*Plus. Collect your dialog. Be sure to include each of the following SQL scripts in your report. Follow the instructor’s instruction concerning any additional required items, any needed sign-offs, and the due date of this report.

Use SQL to create the following reports.

1. In order to fit the output on the page set line size to 100 and the page size to 50. Generate a script file named customer_report.sql that displays the name, street, city, state, and zip code for each customer. Concatenate the city, state and zip code for each customer into a single expression. Insert a comma between the city and state data. Execute this script file.

2. Copy the customer_report.sql file to the customer_report2.sql file. Create a view within this customer_report2.sql script file. This view named customer_report should display the attributes displayed in item #1 above. The columns names should be CUST_NAME, CUST_STREET_ADDRESS, and CUST_CITY_STATE_ZIP. This script should display the contents of this view. Execute this script file to create and display this view.

3. Develop the customer_report_format.sql script file that removes old headings and creates the column headings in the customer_report view to CUSTOMER NAME, CUSTOMER ADDRESS, and CUSTOMER CITY/STATE/ZIP. Be sure to place the word “CUSTOMER” on the first line and the remaining words are displayed on the second line. Be sure that the script file displays all the data in the customer_report view. Execute this script file.

4. Copy the customer_report_format.sql file to the customer_report_format2.sql file. Change the customer_report_format2.sql script file so that the format of the CUSTOMER_NAME column is 35 characters wide. Execute the script file.

5. Generate a representative_report.sql script file. Be sure that this script file contains the representative_report view that displays the sales representative full name as first name, space, and last name (named REP_NAME), his/her total commission (named REP_COMM), and his/her commission rate (named REP_RATE). The sales representative name should be displayed as last name, comma, space, and first name. Include a statement to display the view. Execute this script file to create and display the view.

6. Develop a script file named representative_report_format.sql that formats the data from the representative_report view. The total commission should appear as currency and the commission rate should appear with two decimal places and a leading zero in front of the decimal point. Modify the column headings so that “Sales Rep.” and “Name” are on separate lines, “Total” and “Commission” are on separate lines, and “Commission” and “Rate” are on separate lines. The final command should display the complete view. Execute this script file.

Name Null? Type ----------------------------------------------------- -------- ------------------------------------ CUST_ID NOT NULL CHAR(4) CUST_NAME VARCHAR2(30) CUST_STREET VARCHAR2(20) CUST_CITY VARCHAR2(20) CUST_STATE CHAR(2) CUST_ZIP CHAR(5) CUST_BALANCE NUMBER(8,2) CUST_LIMIT NUMBER(8,2) REP_ID CHAR(3)

SQL> DESCRIBE REP; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ REP_ID NOT NULL CHAR(3) REP_LNAME VARCHAR2(20) REP_FNAME VARCHAR2(15) REP_STREET VARCHAR2(20) REP_CITY VARCHAR2(15) REP_STATE CHAR(2) REP_ZIP CHAR(5) REP_COMM NUMBER(7,2) REP_RATE NUMBER(3,2)

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignments
Pro Writer
Engineering Solutions
Accounting Homework Help
Fatimah Syeda
Homework Guru
Writer Writer Name Offer Chat
Instant Assignments

ONLINE

Instant Assignments

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$19 Chat With Writer
Pro Writer

ONLINE

Pro Writer

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$49 Chat With Writer
Engineering Solutions

ONLINE

Engineering Solutions

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$21 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$29 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$34 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$40 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

A manufacturing company that produces a single product - Lucinda wizard of oz - Looking for Reliable Homework Help: Where Can I Get Quality Assistance for My School Assignments? - How to calculate ka - Is want a linking verb - Pbr master cylinder identification - The boy in the striped pajamas book setting - 2-3 pages apa form - Ship's deck log entry procedures - Facebook whatsapp acquisition case study - Writing assignment 1 - 5 moment hand hygiene - Target golf balls for sale - Horizontal and vertical analysis excel - Entropy change in isobaric process - Iacademy oracle 3 - Shadow health esther park answer key - The three phases of change are - Analysis of a pertinent healthcare issue - Whitehouse farm medical centre - The middle passage documentary by steven spielberg - Synergist muscles in shoulder press - Hershey organizational structure - Can crusher project report - Swot analysis ford motor company 2018 - New depth and complexity icons printable - Ppl Questions - How can I manage my dissertation when I’m short on time and overwhelmed with other responsibilities? - Hey there delilah ukulele - To an athlete dying young questions and answers - Cummins india engine specifications - Imogene king conceptual system - Reply to discussion- Nicole - Week 7 - Advanced Financial Accounting - Comprehensive Consolidation Method - What examples of advocacy do you see in your own nursing practice? List and discuss 2 examples. - Romeo and juliet essay prompts 9th grade - 007d8 - Acrostic generator for words - Precision learning pattern - Jp hyperdome - 1 - Apple inc in case analysis - Project network diagram calculator - Leverage adjusted duration gap example - Discussion! - Technology Advancement – Challenges and Changes - Equivalent units of production are equal to - Queen wealtheow in beowulf - Business Communication - 4 h and 4t - Python programing - Need help composing a short answer question - Fall of humanity then and now worksheet - Why is being organised important - Fe reference handbook 10 pdf - Accident investigation techniques basic theories and applications - Formal analysis art essay - 3267 kj to calories - Kaggle Competition - Cook door menu 2017 egypt - Original jurisdiction refers to - Challenger guaranteed annuity pds - Competitive profile matrix of hershey company - Identify the four challenges associated with e business - Bushmaster mars 1400 telescope - College Essay - East west university grading system - Ultrasonic blind stick project - Stolen party - Ib math studies ia examples - Response - Lección 4 grammar quiz completar - Menschen a2 1 arbeitsbuch - Blank uk driving licence template - Oxidation and reduction examples in daily life - When will cheques be phased out in australia - How to do manova in spss - Paper 8 - Index of password txt - Gatwick airport layout plan - Beautiful soup 4 documentation - Track software inc integrative case 2 - Financial accounting craig deegan - Biostatistics Reflection Discussion - Mission mxb dagger crossbow for sale - Working memory model diagram - Research paper cybersecurity & IOT - Kitchener memorial auditorium complex seating chart - The motivation letter - Must be a detailed answer with no plagiarism. - Iec 60617 pdf free download - Nationstate insurance case study - Invitational speech - Example of soap note nurse practitioner - The arrangement book kmart - Trim software training sydney - 110 konzier drive pittsburgh pa - A paragraph to a friend - Harcourt education catalyst 3 answers