Q5. They also asked you to modify the PRODUCT table by adding 10% to all the prices of 'GTokyo Traders' vendor. SALESREPPK SLSREP_NUMPK CUST NUMCUSTOMERCUST_LNAMECUST_FNAMECUST_AREACODECUST_PHONECUST_E-MAILFK2CUST_SHIP_ADDRESSCUST_SHIP_CITYCUST_SHIP_STATECUST_ZIP_CODEINVOICEPK INV_NUMSLSREP_LNAME-It writes OFK1 CUST_NUMFK2 SLSREP_NUMSLSREP_FNAMESLSREP INITIALINV_DATESLSREP_EMAILINV_SUBTOTALPK,FK1PKIgeneratesINV_TAXINV_TOTALcontainsINV_LINEINV_NUMINV LINE NUMPROD_CODEINV_LINE_PRICEINV_LINE_QUANTINV_LINE_TOTALVENDORPK VEND_CODEVEND NAMEVEND_CONTACTVEND_EMAILIIsuppliesIPRODUCTPROD_CODEPK0 is written in +1-FK1 VEND_CODEPROD_DESCRIPTIONPROD_PRICEPROD_QOH

The solution is given below with demo data in each of the product and vendor tables to understand…

Answered: Q5. They also asked you to modify the…

Engineering

Computer Science

Q5. They also asked you to modify the PRODUCT table by adding 10% to all the prices of 'G Tokyo Traders' vendor.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Ensure that the only legal values for the BDRMS column in the CONDO_UNIT table are 1, 2, or 3.
Surpreeth would want to add two additional customer entries to the customer table. Which command is used to make this happen?
Can someone help? Thank you in advance The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
The InstantRide Driver Relationship team wants to analyze the travel information of the low rated drivers. You will need to provide them with all the travel information of the drivers with the average rating lower than 4. The team wants to get in touch with the travelers and analyze their feedback. You need to run SELECT query and return all travel data from TRAVELS table filtered by the drivers who has lower rating than 4 in the DRIVERS table.
The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER_ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2021-12-28 Driving License Checked: True Rating: 4.0
The 'customer' table contains ten columns but no rows. The table is then updated with 10 new rows and 3 rows discarded. What is the table'customer's degree and cardinality?
Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
The head of hospital auditing wants to know which patients were charged the most for a treatment. The result table should list three columns from the treatment table appropriately labeled: pat_id, actual_charge, and service _id .Only list rows where the patient was charged the most for a treatment. This may result in some rows where patients were charged identical amounts to other patients. Sort the rows by service_id. Use a correlated subquery. Format the output appropriately.
The StayWell marketing team wants to send mail to all residents. You need to return the first name and surname of all the residents combined as NAME, with their addresses named ADDRESS. However, the address should be retrieved from the PROPERTY table for residents. Task Retrieve the mailing address (first name, surname, and address) for each resident.
You have been asked to run a query using the CASE statement to analyze the quantity of shares data in the Order Transactions table. Specifically, you have been asked to determine the number of orders that fall into different order size ranges. There are 150 different orders in the Order Transactions table so if you add up the COUNT data in each of your buckets, you should get 150. You are asked to use five buckets: 1. 0-100, 2. 101-400, 3. 401-800, 4. 801-1000, and 5. 1001 or above. Since these are no order sizes above 1000 shares, you will have to think outside the box to figure out how to include "5. 1001 and Above" in your results table with zero (0) as the COUNT of orders in that bucket. You do not need to use RowNum for any part of this query. Provide working code in Oracle.
What’s the difference between an equality and a non-equality join?