2014
pluralsight
Pankaj Jain
4h 28m
English
Get coding quickly and effectively with Oracle PL/SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL/SQL.
01. Course Introduction 5:53
What is PL/SQL? 1:04
Why learn PL/SQL? 1:43
Audience 1:06
How is PL/SQL Processed? 0:48
Tools 1:11
02. Anonymous Blocks 19:44
Overview 1:04
What is an Anonymous Block? 1:46
Structure of Anonymous Blocks 2:55
Comments in Anonymous Blocks 1:49
Demo of Anonymous Block Structure and Comment Styles 3:13
Nesting of Anonymous Blocks 0:59
Scope and Visibility of Variables in Nested Blocks 1:34
Labels 0:52
Demo: Scope and Visibility of Variables and Block Labels 4:14
Summary 1:15
03. PL/SQL Commonly Used Datatypes 1:04:32
Introduction 1:43
Number: Fixed and Floating Type 4:54
Assignments, Defaults and Constants 1:55
Demo: Numbers 4:41
Subtypes 3:54
%TYPE 3:52
PLS_INTEGER or BINARY_INTEGER 2:03
BINARY_DOUBLE and BINARY_FLOAT 5:40
Character Datatypes 6:47
Demo: Character 1:46
DateTime Datatypes 6:16
Demo: DateTime Datatypes 2:50
Interval Datatype 6:58
Time Datatype Usage Guidelines 0:43
Boolean Datatype 0:34
Composite Datatype: Records 4:41
Composite Datatype: %ROWTYPE 2:38
Other Datatypes 1:39
Summary 0:50
04. Loops 33:10
Overview 4:42
Simple Loops 4:48
Demo: Simple Loops 2:25
FOR Loops 2:32
Demo: FOR Loop 1:02
FOR Loop Counter 5:40
Continue Statement 1:10
Nesting of Loops 1:46
Exit When & Continue When 5:06
While Loop 2:47
Summary 1:07
05. Conditional Execution 24:32
Overview 1:17
If Elseif Else Statements & Nesting 8:24
Demo: If Elsif Else Statements & Nesting 2:53
Case Statement 3:41
Case Expressions 4:18
Demo: Case Statement & Expressions 2:56
Summary 0:59
06. Cursors 54:12
Introduction 2:47
Implicit Cursors 4:42
Demo: Implicit Cursors 2:49
Explicit Cursors 10:00
Cursor FOR Loop 6:41
Cursor FOR Update 6:44
Ref Cursors or Cursor Variables 10:32
Weak Ref Cursors 3:56
Cursor Expressions 4:01
Summary 1:55
07. Exceptions 29:40
Introduction 2:36
Oracle Internal Exceptions 8:31
Predefined Exceptions 2:18
User Defined Exceptions 5:25
Exception Scope & Propagation 9:52
Summary 0:56
08. Debugging 36:47
Introduction 1:57
DBMS_OUTPUT 7:56
DBMS_UTILITY 2:38
Demo: DBMS_OUTPUT & DBMS_UTILITY 6:30
SQLDeveloper Debugger: Privileges & Setup 2:45
Debugging with SQLDeveloper 9:48
Debugging an Exception with SQLDeveloper 4:07
Summary 1:02
Download File Size:577.45 MB
|
