Exercise 2 (1%) Complete the following: Create a view called gl_stdV1 that returns the required data Create an anonymous block that: o Accesses gl_stdV1 o Uses the %ROWTYPE attribute to define a record structure for the view data o Prompts for student number and section id o Output the required information

Exercise 2 (1%) Complete the following: Create a view called gl_stdV1 that returns the required data Create an anonymous block that: o Accesses gl_stdV1 o Uses the %ROWTYPE attribute to define a record structure for the view data o Prompts for student number and section id o Output the required information

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 17MC

See similar textbooks

Similar questions

Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO.
Write, but do not execute, the commands to grant the following privileges: a. User Ashton must be able to retrieve data from the ITEM table. b. Users Kelly and Morgan must be able to add new orders and order lines. c. User James must be able to change the price for all items. d. User Danielson must be able to delete customers. e. All users must be able to retrieve each customers number, name, street, city, state,and postal code. f. f User Pere7 must be able to create an index on the ORDFRS table. g. User Washington must be able to change the structure of the ITEM table. h. User Grinstead must have all privileges on the ORDERS table.
Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the second is the average fee for all condos in the CONDO_UNIT table thathave that square footage. Use AVERAGE_FEE as the column name for the average fee.Group and order the rows by square footage. a. Write and execute the CREATE VIEW command to create the CONDO_FEES view. b. Write and execute the command to retrieve the square footage and average fee foreach square footage for which the average fee is greater than 500. c. Write and execute the query that the DBMS actually executes. d. Does updating the database through this view create any problems? If so, what arethey? If not, why not?
Complete the following in Apex Oracle: • Create a view called gl_stdV1 that returns the required data • Create an anonymous block that: o Accesses gl_stdV1 • Uses the %ROWTYPE attribute to define a record structure for the view data • Prompts for student number and section id • Output the required information
. Create an anonymous block that returns the number of students in a section. Prompt for section id.Name the file Create an anonymous block that return the average numeric grade for a section. Prompt for sectionid and return the average grade. Complete the following:• Create a view called gl_stdV1 that returns the required data• Create an anonymous block that:o Accesses gl_stdV1o Uses the %ROWTYPE attribute to define a record structure for the view datao Prompts for student number and section ido Output the required information • Create an anonymous block that inserts new rows into the gl_professors_copy table• Declare variables using the %ROWTYPE and %TYPE attributes• Use bind/host variables to prompt for the input data• Allow for mixed case when entering the school code• Allow for mixed case when entering the first and last names and format names with firstcharacter in upper case and the remaining character in lower case• Include an INSERT statement in the execution section that…
Create a view named TopLevelCust view. It consists of the number, name, address, balance, and credit limit ofall clients with credit limits that are greater than or equal to $10,000. Display the data in the view.
Kindly provide the output also Create a view called gl_stdV1 that returns the required data • Create an anonymous block that: o Accesses gl_stdV1 o Uses the %ROWTYPE attribute to define a record structure for the view data o Prompts for a student number and section id o Output the required information
1. Write a CREATE VIEW statement that defines a view named InvoiceBasic that returns three columns: VendorName, InvoiceNumber, and InvoiceTotal. Then, write a SELECT statement that returns all of the columns in the view, sorted by VendorName, where the first letter of the vendor name is N, O, or P.
Q1Create a view named v_Title_Unavailable.The view should show the movie titles and media_id of the media not returned yet. The view should not allow any DML operationsQ2Create a SYNONYM for v_Title_Unavailable named vTU.Q3Write SQL to query the view using the synonym.
Use UStayWell Student Accommodation Database to answer the following questions A. Create a view named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name,balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. B. Write and execute the CREATE VIEW command to create the ITEM_INVOICE view. C. List all the views contained within the system catalog.
136. Which statement is true regarding external tables? a. The default REJECT LIMIT for external tables is UNLIMITED b. The data and metadata for an external table are stored outside the database c. ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table d. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table
create view that view names of professors and name of project