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

How large is a wolf pack the following information - Do you capitalise mum and dad - Was pachycephalosaurus a carnivore - Directive purpose of written communication - Wk6 assign 6053 - Amp lifetime super usi - Aim to pass american dream plan - Possible conflict management and negotiation techniques - Discussion response MK - 32 bisley place wakerley - Geopolitical community in which a person would live - Qnt 561 applied business research and statistics final exam - Lab 2 separation of a mixture answers - The trials of durance - Peer evaluation sample essay - Which of the following is an online library penn foster - Www mysciencedoodles com water cycle - Best workout for natural lifters - Comprehensive medical report - Invictus meaning line by line - Oscar a que hora pensar volver - Waren sports supply balance sheet 2017 - Secondary traumatisation in international victimology - Bocam park pencoed jobs - What counseling theory am i - Financial reporting problem ii part 1 - Temperate forest animals facts - Cast a spell spelling program - Scm - Who started the ehr mandate - How to prepare caustic soda - Gcse business market research - Managerial Economics: Professional Assignment - Complete the company's cash budget for the upcoming fiscal year - Mcgraw hill connect accounting answers chapter 4 - Creswell and creswell research design pdf - Write about one of your self defeating behavior patterns - Why are elements and compounds considered pure substances - Stat 200 assignment 1 descriptive statistics data analysis plan - Chapter 3 exponential logistic and logarithmic functions 3.1 major concepts - Evaluate the iterated integral. 1 0 s4 cos(s5) dt ds 0 - 10 48 police code - UML diagram - It’s crucial that cost variances and inefficiencies be identified early so that - Lord of the flies excerpt - Need 400- 500 words on the following topic - A beautiful mind psychology assignment - Fsr meaning in banking - Every good boy deserves football - 4-6 pages Internship Experience - in IT field - Maria filippov eamon mccrory - Reply to each post (Must be 175 words long) in your owe words. - Give me liberty 6th edition volume 2 pdf - Urgent 1- 7 hours due - Case 1 2 nestle the infant formula controversy answers - Macbeth background step 2 the history of the play answers - Business ethics shaw 9th edition - Drew marine product catalogue - Aca code of ethics - Homer tomorrow when the war began - Kiran bedi ted talk - Gs2 series ac drive manual - Theory of ferrous phosphate syrup - Infj humanmetricswhy is it important to address opposing point of views within your argumentative essay? - Exam - Cae practice tests listening - English II-Assigment 5-REVISION - The sea the sea analysis - HSA5400-Deliverable 4 – Conducting a Comparative Financial Analysis Executive Summary - Suicide prevention job aid brochure - Violent video games should be banned - Case tools are mainly used during the ____ phase of the sdlc. - 560 paper - Downlink data notification lte - Quickbooks chapter 5 answers - Cathodic protection system maintenance - Strategic offensives should be based on - How you put people together affects? - 41 the spanish american war crossword answers - Walmart in china case study - Castle view house east lane runcorn - How to make histogram in excel mac 2011 - Self reflection strengths and weaknesses essay - Which of the following is not true for strategic management - How to change the theme to retrospect in excel - Mike walker pam royle - Concept cartoons in mathematics - Fern fort university swot analysis template - Markel m 2015 technical communication 11th ed - A trainer has a client request their records - Application of pender's health promotion model - Institutionalized organizations formal structure as myth and ceremony - Babette's feast discussion guide - Incision and drainage icd 10 code - Half wave rectifier experiment observations with conclusion - Types of support in writing - For prof avril - Lunch at haidilao december 7 - Management - Connie's tambourine man a new reading of arnold friend