Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    Composite Data Types4

    Uploaded by

    Md. Shamsul Haque
    The document discusses composite data types in PL/SQL including records, the %ROWTYPE attribute, INDEX BY tables, explicit cursors, and how to declare, open, fetch from, close cursors and use the %NOTFOUND and %ROWCOUNT attributes.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Composite Data Types4

    Uploaded by

    Md. Shamsul Haque
    20 views1 page
    The document discusses composite data types in PL/SQL including records, the %ROWTYPE attribute, INDEX BY tables, explicit cursors, and how to declare, open, fetch from, close cursors and use the %NOTFOUND and %ROWCOUNT attributes.

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses composite data types in PL/SQL including records, the %ROWTYPE attribute, INDEX BY tables, explicit cursors, and how to declare, open, fetch from, close cursors and use the %NOTFOUND and %ROWCOUNT attributes.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    20 views1 page

    Composite Data Types4

    Uploaded by

    Md. Shamsul Haque
    The document discusses composite data types in PL/SQL including records, the %ROWTYPE attribute, INDEX BY tables, explicit cursors, and how to declare, open, fetch from, close cursors and use the %NOTFOUND and %ROWCOUNT attributes.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 1

    Composite Data Types

    Use PL/SQL Records


    The %ROWTYPE Attribute
    Insert and Update with PL/SQL Records
    INDEX BY Tables
    Examine INDEX BY Table Methods
    Use INDEX BY Table of Records
    Explicit Cursors
    What are Explicit Cursors?
    Declare the Cursor
    Open the Cursor
    Fetch data from the Cursor
    Close the Cursor
    Cursor FOR loop
    The %NOTFOUND and %ROWCOUNT Attributes
    Describe the FOR UPDATE Clause and WHERE CURRENT Clause

    You might also like