Oracle PL/SQL Fundamentals - Part 1

—Introduction 1m 43s
—Number: Fixed and Floating Type 4m 54s
—Assignments, Defaults and Constants 1m 55s
—Demo: Numbers 4m 41s
—Subtypes 3m 54s
—%TYPE 3m 52s
—PLS_INTEGER or BINARY_INTEGER 2m 3s
—BINARY_DOUBLE and BINARY_FLOAT 5m 40s
—Character Datatypes 6m 47s
—Demo: Character 1m 46s
—DateTime Datatypes 6m 16s
—Demo: DateTime Datatypes 2m 50s
—Interval Datatype 6m 58s
—Time Datatype Usage Guidelines 0m 43s
—Boolean Datatype 0m 34s
—Composite Datatype: Records 4m 41s
—Composite Datatype: %ROWTYPE 2m 38s
—Other Datatypes 1m 39s
—Summary 0m 50s

—Overview 4m 42s
—Simple Loops 4m 48s
—Demo: Simple Loops 2m 25s
—FOR Loops 2m 32s
—Demo: FOR Loop 1m 2s
—FOR Loop Counter 5m 40s
—Continue Statement 1m 10s
—Nesting of Loops 1m 46s
—Exit When & Continue When 5m 6s
—While Loop 2m 47s
—Summary 1m 7s

—Overview 1m 17s
—If Elseif Else Statements & Nesting 8m 24s
—Demo: If Elsif Else Statements & Nesting 2m 53s
—Case Statement 3m 41s
—Case Expressions 4m 18s
—Demo: Case Statement & Expressions 2m 56s
—Summary 0m 59s

—Introduction 2m 47s
—Implicit Cursors 4m 42s
—Demo: Implicit Cursors 2m 49s
—Explicit Cursors 10m 0s
—Cursor FOR Loop 6m 41s
—Cursor FOR Update 6m 44s
—Ref Cursors or Cursor Variables 10m 32s
—Weak Ref Cursors 3m 56s
—Cursor Expressions 4m 1s
—Summary 1m 55s

—Introduction 2m 36s
—Oracle Internal Exceptions 8m 31s
—Predefined Exceptions 2m 18s
—User Defined Exceptions 5m 25s
—Exception Scope & Propagation 9m 52s
—Summary 0m 56s

—Introduction 1m 57s
—DBMS_OUTPUT 7m 56s
—DBMS_UTILITY 2m 38s
—Demo: DBMS_OUTPUT & DBMS_UTILITY 6m 30s
—SQLDeveloper Debugger: Privileges & Setup 2m 45s
—Debugging with SQLDeveloper 9m 48s
—Debugging an Exception with SQLDeveloper 4m 7s
—Summary 1m 2s