Pl sql declare type

1: Introduction

• Introduction
• Practice Getting Started

2: Introduction to PL/SQL

• Introduction to PL/SQL
• Practice Introduction to PL/SQL

3: Declaring PL/SQL Variables

• Declaring PL/SQL Variables
• The %TYPE Attribute
• Practice Declaring PL/SQL Variables

4: Writing Executable Statements

• Writing Executable Statements
• Practice Writing Executable Statements

5: Using SQL Statements Within a PL/SQL Block

• Using SQL Statements Within a PL/SQL Block
• Practice Using SQL Statements Within a PL/SQL

6: Writing Control Structures

• Writing Control Structures
• Basic Loop: Example
• Practice Writing Control Structures

7: Working with Composite Giorno Types

• Working with Composite Giorno Types
• Associative Arrays (INDEX BY Tables)
• Practice Working with Composite Giorno Types

8: Using Explicit Cursors

• Using Explicit Cursors
• Cursor FOR Loops
• Practice Using Explicit Cursors
• Practice Using Explicit Cursors: Optional

9: Handling Exceptions

• Handling Exceptions
• Practice Handling Predefined Exceptions
• Practice Handling Standard Oracle Server Exceptions

Introducing Stored Procedures and Functions

• Introducing Stored Procedures and Functions
• Practice Creating and Using Stored Procedures

Creating Procedures

Creating Procedures

• Practice Creating and Using a New SQL Developer Database Connection
• Practice Creating, Compiling, and Calling Procedures

Creating Functions

• Creating Functions
• Practice Creating Functions

Debugging Subprograms

• Debugging Subprograms
• Practice Introduction to the SQL Developer Debugger

Creating Packages

• Creating Packages
• Practice Creating and Using Packages

Working with Packages

• Working with Packages
• Practice Working with Packages

Using Oracle-Supplied Packages in Application Development

• Using Oracle-Supplied Packages in Application Development
• Practice Using the UTL_FILE Package

Using Dynamic SQL

• Using Dynamic SQL
• Practice Using Native Dynamic SQL

Creating Triggers

• Creating Triggers
• Practice Creating Statement and Row Triggers

Creating Compound, DDL, and Event Database Triggers

• Creating Compound, DDL, and Event Database Triggers
• Practice Managing Giorno Integrity Rules and Mutating Table Exceptions

Design Considerations for the PL/SQL Code

• Design Considerations for the PL/SQL Code
• Practice Using Bulk Binding and Autonomous Transactions

Tuning the PL/SQL Compiler

• Tuning the PL/SQL Compiler
• Practice Using the PL/SQL Compiler Parameters and Warnings

Managing Dependencies

• Managing Dependencies
• Practice Managing Dependencies in Your Schema