Learn PL/SQL


  • WatchPLS-1: Introduction to Oracle PL/SQL
  • WatchPLS-2: My First PL/SQL Program
  • WatchPrivate video
  • WatchPLS-4: PL/SQL Variables
  • WatchPrivate video
  • WatchPLS-6: Using SQL Functions in PL/SQL
  • WatchPLS-7: PL/SQL Selection Control Structure
  • WatchPrivate video
  • WatchPLS-9: Oracle PL/SQL Cursor
  • WatchPLS-10: Oracle Pl/SQL Cursors With Parameters
  • WatchPLS-11: Oracle PL/SQL Reference Cursor
  • WatchPLS-12: PL/SQL Bulk Collect and Bulk Bind
  • WatchPLS-13: PL/SQL Records Data Type
  • WatchPLS-14: Pl/SQL VARRAY Composite Data Type
  • WatchPrivate video
  • WatchPLS-16: PL/SQL Index By Table
  • WatchPLS-17: Predefined Exceptions in Oracle
  • WatchPLS-18: Non Predefined Exceptions in PL/SQL
  • WatchPLS-19: User Defined Exceptions in PL/SQL
  • WatchPrivate video
  • WatchPLS-21: PL/SQL Stored Procedure
  • WatchPLS-22: Using Parameters in PL/SQL Procedure
  • WatchPLS-23: PL/SQL Stored Functions
  • WatchPLS-24: PL/SQL Package Introduction
  • WatchPLS-25: Visibility Rules in PL/SQL Packages
  • WatchPLS-26: Stored Program Overloading in PL/SQL
  • WatchPLS-27: PL/SQL Project Executive Summary
  • WatchHow to trigger a schema related event
  • WatchHow to trigger a System Events
  • WatchUse of Triggers - How to Update Read Only Views
  • WatchUse of Triggers: - Example of Auditing a Column
  • WatchUse of Triggers - How to keep related values in sync
  • WatchHow to Ensure a Business Rule Using Triggers
  • WatchDatabase Triggers Intuition