PL/SQL is an extension of SQL for the Oracle Database.
Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.
The book contains tons of examples that prepare you for real-world development project.
This book is considered the best Oracle PL/SQL programming guide by the Oracle community.
The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.
Here is what you will learn
Chapter 1: Introduction
What Is PL/SQL?
Architecture of PL/SQL
Advantage of Using PL/SQL
Basic Difference between SQL and PL/SQL
Chapter 2: Blocks
What is PL/SQL block?
Block Structure
Types of PL/SQL block
Chapter 3: First Program: Hello World
SQL Plus
Connecting to Database
How to write a simple program using PL/SQL
Declaring and usage of variables in program
Commenting Codes
Chapter 4: Data Types
CHARACTER
NUMBER
BOOLEAN
DATE
LOB
Chapter 5: Complex Data Types
Record Type
Collection
Constructor and Initialization Concept in Collections
Collection Methods
Chapter 6: Decision Making Statements
Introduction to Decision Making Statements
IF-THEN Statement
IF-THEN-ELSE Statement
IF-THEN-ELSIF Statement
NESTED-IF Statement
CASE Statement
SEARCHED CASE Statement
Chapter 7: Loops
Introduction to Loops Concept
Loop Control Statements
Types of Loop in PL/SQL
Nested Loops
Labelling of Loops
Chapter 8: Subprograms: Procedures and Functions
Terminologies in PL/SQL Subprograms
Procedure
Function
Similarities between Procedure and Function
Difference between Procedure and Function
Built-in Functions in PL/SQL
Chapter 9: Exception Handling
Exception-Handling
Predefined Exceptions
User-defined Exception
Raising an Exception
Important points to note in Exception
Chapter 10: SQL
DML Transactions in PL/SQL
CURSOR Concept in PL/SQL
Cursor Attributes
FOR Loop Cursor statement
BULK COLLECT in PL/SQL
TCL Statements in PL/SQL
Autonomous Transaction
Chapter 11: Packages
Components of Packages
Package Initialization
Forward Declarations
Overloading
Package Information
UTL FILE – An Overview
Chapter 12: Triggers
Benefits of Triggers
Trigger Classification
Trigger Creation
:NEW and :OLD Clause
INSTEAD OF Trigger
Compound Trigger
Chapter 13: Object Types
Components of Object Types
Creation of Objects
Declaration Initialization of Object Type
Constructors
Inheritance in Object Type
Equality of PL/SQL Objects
Chapter 14: Dynamic SQL
Ways to write dynamic SQL
NDS
DBMS_SQL for Dynamic SQL
Chapter 15: Nested Blocks
Nested Block Structure
Scopes in Nested Block
Chapter 16: Identifiers
Properties of Identifiers
Naming Conventions of Identifiers
Variables – An Identifier
Declaration of Variables
Data storing in Variables
