Learn PL/SQL in 1 Day: Definitive Guide to Learn PL/SQL for Beginners / Krishna Rungta

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