Built-in PL/SQL procedures and functions - Oracle Database Tutorial

Contents

• Introduction Introduction

  • Oracle Database PL/SQL: Why use it with Oracle Database 19c?

    1m 27s
  • Prerequisites

    1m 57s
• 1. PL/SQL Elements 1. PL/SQL Elements

  • (Locked)
    Overview of PL/SQL

    5m 15s
• 2. Procedures and Functions 2. Procedures and Functions

  • Built-in PL/SQL procedures and functions

    5m 15s
  • (Locked)
    Creating functions

    5m 51s
  • (Locked)
    Creating procedures

    5m 32s
• 3. Declaration Section 3. Declaration Section

  • (Locked)
    Declaring variables

    4m 28s
  • (Locked)
    Declaring cursors

    3m 26s
• 4. Security Model 4. Security Model

  • (Locked)
    Invoker rights versus definer rights

    5m 46s
  • (Locked)
    How blocks define scope

    5m 25s
• 5. Conditional Statements 5. Conditional Statements

  • (Locked)
    Programming contstructs: FOR loop

    5m 57s
  • (Locked)
    Programming constructs: WHILE loop

    5m 1s
  • (Locked)
    Programming constructs: LOOP

    4m 12s
  • (Locked)
    Programming constructs: IF statement

    3m 25s
  • (Locked)
    Programming constructs: CONTINUE and EXIT

    3m 31s
  • (Locked)
    New features of PL/SQL loop constructs

    3m 14s
• 6. Using SQL SELECT Statements 6. Using SQL SELECT Statements

  • (Locked)
    Programming constructs: SELECT INTO and %ROWCOUNT

    4m 52s
  • (Locked)
    Running SQL statements: Static

    5m 13s
  • (Locked)
    Running SQL statements: Dynamic

    4m 41s
• 7. Error Handling 7. Error Handling

  • (Locked)
    Error handling with EXCEPTION

    4m 12s
  • (Locked)
    User-defined exception types

    5m 7s
• 8. Leveraging User-Defined Types 8. Leveraging User-Defined Types

  • (Locked)
    Declaring and using user-defined types

    7m 40s
  • (Locked)
    Using type with TABLE functions

    4m 26s
• Conclusion Conclusion

  • (Locked)
    Keep going and connect

    1m 19s