BuyFindarrow_forward

A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273
BuyFindarrow_forward

A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273
Chapter 8, Problem 7CAT
Textbook Problem
37 views

Write a stored procedure in PL/SQL or T-SQL that will change the maximum group size of a trip with a given trip ID. How would you use this stored procedure to change the maximum group size of trip 21 to 15?

Program Plan Intro

Stored procedures:

  • When user expect to running a particular query often, user can expand total performance by saving the query in a file called a stored procedure.
    • The stored procedure is located on the server.
    • The DBMS compiles the stored procedure and creates an execution plan, which is the well-organized method of finding the results.
  • It is a procedure which contains collection of procedural and SQL statements.

Syntax for stored procedure:

CREATE FUNCTION fun_name(argument IN data-type)RETRUN data-type[IS]

BEGIN

    PL/SQL statements;

    Return (value or expression);

END;

Explanation of Solution

Query to create stored procedure:

CREATE OR REPLACE PROCEDURE CHANGE_MAX_GROUP_SIZE

(I_TRIP_ID IN TRIP.TRIP_ID%TYPE,

I_MAX_GRP_SIZE IN TRIP.MAX_GRP_SIZE%TYPE) AS

BEGIN

UPDATE TRIP

SET MAX_GRP_SIZE = I_MAX_GRP_SIZE

WHERE TRIP_ID = I_TRIP_ID;

END;

/

Explanation:

  • The above query is used to create a procedure named “CHANGE_MAX_GROUP_SIZE” to select the records in the “TRIP” table.
  • Pass the “I_TRIP_ID” and “I_MAX_GRP_SIZE” as the parameters.
  • Update the “I_MAX_GRP_SIZE” value for the corresponding “I_TRIP_ID” value...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 8 Solutions

A Guide to SQL
Show all chapter solutions
add
Ch. 8 - How do you place the results of a SELECT command...Ch. 8 - Can you use INSERT, UPDATE, or DELETE commands...Ch. 8 - How do you use a SELECT command that retrieves...Ch. 8 - Which PL/SQL command activates a cursor?Ch. 8 - Which PL/SQL command selects the next row in a...Ch. 8 - Which PL/SQL command deactivates a cursor?Ch. 8 - How do you use SQL commands in Access?Ch. 8 - How do you process a collection of rows retrieved...Ch. 8 - How do you move to the next record in a recordset...Ch. 8 - What are triggers? What purpose do they serve?Ch. 8 - What is the purpose of the INSERTED and DELETED...Ch. 8 - When you run the following SQL command, the result...Ch. 8 - Use the TAL Distributors database (see Figure 1-2...Ch. 8 - List the customer number and name for all...Ch. 8 - List the customer number, name, and balance for...Ch. 8 - TAL Distributors is running a promotion that is...Ch. 8 - Write PL/SQL or T-SQL procedures to accomplish the...Ch. 8 - Write PL/SQL or T-SQL procedures to retrieve and...Ch. 8 - Write Access functions to accomplish the following...Ch. 8 - Write a stored procedure in PL/SQL or T-SQL that...Ch. 8 - Write the code for the following triggers in...Ch. 8 - Oracle SQL includes several date and time...Ch. 8 - Use the Colonial Adventure Tours database (see...Ch. 8 - List the trip ID and trip name for all trips that...Ch. 8 - List the reservation ID, trip date, and price for...Ch. 8 - Write PL/SQL or T-SQL procedures to accomplish the...Ch. 8 - Write PL/SQL or T-SQL procedures to retrieve and...Ch. 8 - Write Access functions to accomplish the following...Ch. 8 - Write a stored procedure in PL/SQL or T-SQL that...Ch. 8 - Because the TRIP table contains several columns...Ch. 8 - Use the Solmaris Condominium Group database (see...Ch. 8 - List the owner number and last name for all owners...Ch. 8 - Solmaris is offering a monthly discount for owners...Ch. 8 - Write PL/SQL or T-SQL procedures to accomplish the...Ch. 8 - Write PL/SQL or T-SQL procedures to retrieve and...Ch. 8 - Write Access functions to accomplish the following...Ch. 8 - Write a stored procedure in PL/SQL or T-SQL that...Ch. 8 - SQL includes many numerical functions. Two of...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What are the basic characteristics of a NoSQL database?

Database Systems: Design, Implementation, & Management

What are the basic characteristics of a NoSQL database?

Database Systems: Design, Implementation, & Management

What are the two types of EDM machines?

Precision Machining Technology (MindTap Course List)

Using the concepts discussed in this chapter, measure the volumetric flow rate of water out of a drinking fount...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Why would a systems analyst have to act as a translator? What groups might be involved?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

What is the purpose of a lock screen?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Describe the relation between voltage and amperage for welding current.

Welding: Principles and Applications (MindTap Course List)