- Course
- Data
Oracle PL/SQL Fundamentals - Part 1
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.
What you'll learn
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.
Table of contents
- Overview | 1m 4s
- What is an Anonymous Block? | 1m 46s
- Structure of Anonymous Blocks | 2m 55s
- Comments in Anonymous Blocks | 1m 49s
- Demo of Anonymous Block Structure and Comment Styles | 3m 13s
- Nesting of Anonymous Blocks | 59s
- Scope and Visibility of Variables in Nested Blocks | 1m 34s
- Labels | 52s
- Demo: Scope and Visibility of Variables and Block Labels | 4m 14s
- Summary | 1m 15s
About the author
Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.