Stored procedures:

Stored procedure is a collection of procedural and SQL code statements; it is directly called to operate against the data in the database.

It has a unique name with the schema and stored in the database.

A procedure may have input parameter, and output parameter.

Stored procedures are stored in the database, and it will run whenever it is invoked.

Advantages of stored procedure:

Stored procedures are designed and optimized to run more quickly.

It is used to encapsulate and represent business transactions.

Stored procedure reduces network traffic and also increases performance, because it is stored at the server and there won’t occur any transmission of individual SQL statements over the network...

Expert Solution & Answer

Chapter 8 Solutions

Database Systems: Design, Implementation, & Management

Ch. 8 - Prob. 1RQ Ch. 8 - Explain why it might be more appropriate to...Ch. 8 - What is the difference between a column constraint...Ch. 8 - What are referential constraint actions?Ch. 8 - What is the purpose of a CHECK constraint?Ch. 8 - Explain when an ALTER TABLE command might be...Ch. 8 - What is the difference between an INSERT command...Ch. 8 - What is the difference between using a subquery...Ch. 8 - What is the difference between a view and a...Ch. 8 - Prob. 10RQ

Ch. 8 - Prob. 11RQ Ch. 8 - Prob. 12RQ Ch. 8 - Write the SQL code that will create only the table...Ch. 8 - Having created the table structure in Problem 1,...Ch. 8 - Prob. 3P Ch. 8 - Write the SQL code that will save the changes made...Ch. 8 - Write the SQL code to change the job code to 501...Ch. 8 - Write the SQL code to delete the row for William...Ch. 8 - Write the SQL code to create a copy of EMP_1,...Ch. 8 - Using the EMP_2 table, write the SQL code that...Ch. 8 - Using the EMP_2 table, write the SQL code to...Ch. 8 - Prob. 10P Ch. 8 - Prob. 11P Ch. 8 - Prob. 12P Ch. 8 - Prob. 13P Ch. 8 - Prob. 14P Ch. 8 - Prob. 15P Ch. 8 - Create the CUSTOMER table structure illustrated in...Ch. 8 - Create the INVOICE table structure illustrated in...Ch. 8 - Prob. 18P Ch. 8 - Prob. 19P Ch. 8 - Create an Oracle sequence named CUST_NUM_SEQ to...Ch. 8 - Create an Oracle sequence named INV_NUM_SEQ to...Ch. 8 - Prob. 22P Ch. 8 - Modify the CUSTOMER table to include the customers...Ch. 8 - Prob. 24P Ch. 8 - Prob. 25P Ch. 8 - Create a trigger named trg_updatecustbalance to...Ch. 8 - Prob. 27P Ch. 8 - Prob. 28P Ch. 8 - Write a trigger to update the customer balance...Ch. 8 - Prob. 30P Ch. 8 - Create a trigger named trg_line_total to write the...Ch. 8 - Create a trigger named trg_line_prod that...Ch. 8 - Create a stored procedure named prc_inv_amounts to...Ch. 8 - Create a procedure named prc_cus_balance_update...Ch. 8 - Modify the MODEL table to add the attribute and...Ch. 8 - Prob. 36P Ch. 8 - Modify the CHARTER table to add the attributes...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the sequence of commands required to update...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Write the command required to update the...Ch. 8 - Prob. 43P Ch. 8 - Create a trigger named trg_char_hours that...Ch. 8 - Create a trigger named trg_pic_hours that...Ch. 8 - Create a trigger named trg_cust_balance that...Ch. 8 - Write the SQL code to create the table structures...Ch. 8 - The following tables provide a very small portion...Ch. 8 - For Questions 49-63, use the tables that were...Ch. 8 - Prob. 50P Ch. 8 - Write a single SQL command to increase all price...Ch. 8 - Alter the DETAILRENTAL table to include a derived...Ch. 8 - Update the DETAILRENTAL table to set the values in...Ch. 8 - Alter the VIDEO table to include an attribute...Ch. 8 - Update the VID_STATUS attribute of the VIDEO table...Ch. 8 - Alter the PRICE table to include an attribute...Ch. 8 - Prob. 57P Ch. 8 - Prob. 60P

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Solution Summary: The author explains that stored procedures are a collection of procedural and SQL code statements that are directly called to operate against the data in the database.

Concept explainers

Explanation of Solution

Chapter 8 Solutions