tailieunhanh - processing queries by using explicit cursors

You may need to use a multiple row SELECT statement within PL/SQL to process many rows. To accomplish this, you declare and control explicit cursors, which are used in loops, including the cursor FOR loop. At the end of this lesson, you should be able to Explain the difference between implicit and explicit cursors. Declare and use explicit cursors to fetch rows from the database. Create an explicit cursor containing parameters. Write cursor FOR loops. | 24 Processing Queries by Using Explicit Cursors ORACLG Objectives Explain the difference between implicit and explicit cursors. Declare and explain explicit cursors to fetch rows from the database. Create an explicit cursor with parameters. Write cursor FOR loops. 24-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives You may need to use a multiple row SELECT statement within PL SQL to process many rows. To accomplish this you declare and control explicit cursors which are used in loops including the cursor FOR loop. At the end of this lesson you should be able to Explain the difference between implicit and explicit cursors. Declare and use explicit cursors to fetch rows from the database. Create an explicit cursor containing parameters. Write cursor FOR loops. Processing Queries by Using Explicit Cursors .