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 16RQ
Textbook Problem
117 views

Which PL/SQL command deactivates a cursor?

Program Plan Intro

PL/SQL:

  • In Oracle, the stored procedures can be created using a language called PL/SQL.
  • The procedures are created and saved as the script files.
  • SQL is used to perform the DML and DDL operations using the single query.
  • Whereas the PL/SQL uses a block of codes to write the entire program in terms of blocks or procedures or functions.

Cursor:

Cursor is used to retrieve information in row by row fashion. If the records stored in the database table needs to update one row at a time, then this is carried out by the cursor.

Explanation of Solution

Command to deactivate a cursor:

The PL/SQL command which deactivates a cursor is “CLOSE”. It also executes the query in the cursor definition.

Example:

/*Command to activate a cursor*/

OPEN mycursor

/*Command to select next row from the cursor*/

FETCH NEXT FROM My_cursor

INTO @empNum, @empName

/�...

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
Why is an object said to have greater semantic content than an entity?

Database Systems: Design, Implementation, & Management

What are two reasons for center drilling on the lathe?

Precision Machining Technology (MindTap Course List)

The most commonly used brake fluid in domestic vehicles is: DOT 2 DOT 3 DOT 4 DOT 5

Automotive Technology: A Systems Approach (MindTap Course List)

The tank shown in the accompanying figure is being filled by pipes 1 and 2. If the water level is to remain con...

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

Convert 10,000 ft-lbf of energy into BTU, Joules, and kilojoules.

Fundamentals of Chemical Engineering Thermodynamics (MindTap Course List)

Most users today work with a command-line interface.

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)

What is the key to preventing accidents in a welding shop?

Welding: Principles and Applications (MindTap Course List)