Creating procedures - 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

  • Overview of PL/SQL

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

  • Built-in PL/SQL procedures and functions

    5m 15s
  • Creating functions

    5m 51s
  • Creating procedures

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

  • Declaring variables

    4m 28s
  • Declaring cursors

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

  • Invoker rights versus definer rights

    5m 46s
  • How blocks define scope

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

  • Programming contstructs: FOR loop

    5m 57s
  • Programming constructs: WHILE loop

    5m 1s
  • Programming constructs: LOOP

    4m 12s
  • Programming constructs: IF statement

    3m 25s
  • Programming constructs: CONTINUE and EXIT

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

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

  • Programming constructs: SELECT INTO and %ROWCOUNT

    4m 52s
  • Running SQL statements: Static

    5m 13s
  • Running SQL statements: Dynamic

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

  • Error handling with EXCEPTION

    4m 12s
  • User-defined exception types

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

  • Declaring and using user-defined types

    7m 40s
  • Using type with TABLE functions

    4m 26s
• Conclusion Conclusion

  • Keep going and connect

    1m 19s