2014
pluralsight.com
Pankaj Jain
4h28m
English
In this course you will learn about the fundamentals of Oracle PL/SQL programming language. You will gain a solid understanding of Pl/SQL datatypes and programming constructs like loops, conditional execution, cursors and exception handling, which will enable you to do effective debugging.
Course Introduction
What is PL/SQL?
Why learn PL/SQL?
Audience
How is PL/SQL Processed?
Tools
Anonymous Blocks
Overview
What is an Anonymous Block?
Structure of Anonymous Blocks
Comments in Anonymous Blocks
Demo of Anonymous Block Structure and Comment Styles
Nesting of Anonymous Blocks
Scope and Visibility of Variables in Nested Blocks
Labels
Demo: Scope and Visibility of Variables and Block Labels
Summary
PL/SQL Commonly Used Datatypes
Introduction
Number: Fixed and Floating Type
Assignments, Defaults and Constants
Demo: Numbers
Subtypes
%TYPE
PLS_INTEGER or BINARY_INTEGER
BINARY_DOUBLE and BINARY_FLOAT
Character Datatypes
Demo: Character
DateTime Datatypes
Demo: DateTime Datatypes
Interval Datatype
Time Datatype Usage Guidelines
Boolean Datatype
Composite Datatype: Records
Composite Datatype: %ROWTYPE
Other Datatypes
Summary
Loops
Overview
Simple Loops
Demo: Simple Loops
FOR Loops
Demo: FOR Loop
FOR Loop Counter
Continue Statement
Nesting of Loops
Exit When & Continue When
While Loop
Summary
Conditional Execution
Overview
If Elseif Else Statements & Nesting
Demo: If Elsif Else Statements & Nesting
Case Statement
Case Expressions
Demo: Case Statement & Expressions
Summary
Cursors
Introduction
Implicit Cursors
Demo: Implicit Cursors
Explicit Cursors
Cursor FOR Loop
Cursor FOR Update
Ref Cursors or Cursor Variables
Weak Ref Cursors
Cursor Expressions
Summary
Exceptions
Introduction
Oracle Internal Exceptions
Predefined Exceptions
User Defined Exceptions
Exception Scope & Propagation
Summary
Debugging
Introduction
DBMS_OUTPUT
DBMS_UTILITY
Demo: DBMS_OUTPUT & DBMS_UTILITY
SQLDeveloper Debugger: Privileges & Setup
Debugging with SQLDeveloper
Debugging an Exception with SQLDeveloper
Summary
http://pluralsight.com/training/Courses/TableOfContents/oracle-plsql-fundamentals
Download File Size:573.07 MB
|
