Mastering PL/SQL Through Illustrations

Mastering PL/SQL Through Illustrations

From Learning Fundamentals to Developing Efficient PL/SQL Blocks

person icon Dr. B. Chandra

ebook icon BPB Publications

language icon Language - English

updated on icon Updated on Jan, 2021

architecture icon Development,Databases,SQL


This eBook includes

Formats : EPUB, PDF (Downlodable)

Pages : 288

ISBN : 9789389898484

Language : English

About the Book

Book description

Mastering PL/SQL using various database tables

Key Features

● Creating PL/SQL blocks using database tables.
● Cursors and Cursor For loops.
● Functions and Procedures in PL/SQL.
● Triggers and Packages.
● Exceptions in PL/SQL.
● Collections and its methods.


This book helps you to improve your employability and job market so that you can sprint towards a rewarding career in the area of databases. . You will learn PL/SQL starting from fundamentals to advanced level. The detailed description of Cursors will enable you to write professional codes using Cursors in PL/SQL. You will learn how to raise exceptions when errors are encountered, create Triggers before/after a DML operation, create Functions /Procedures and packages.. By the end of the book, you will be able to use collections and also write advanced PL/SQL blocks using database tables with ease.

What will you learn

● Get an overview of Control Structures and Loops in PL/SQL.
● Understand the working of Cursors and Cursor FOR LOOPS.
● Learn how to create triggers, packages, functions and procedures in PL/SQL.
● Learn how to handle errors by raising Exceptions.
● Learn how to use Collections in PL/SQL.

Who this book is for

This book is for those who want to learn PL/SQL and its applications in depth. It is also best suited for professionals looking to pursue a career in the area of databases as a Database Administrator /Developer.

Table of Contents

1. Introduction to Pl/Sql
2. Pl/Sql Control Structures
3. Loops in Pl/Sql
4. Cursors in Pl/Sql
5. Exceptions in Pl/Sql
6. Procedures in Pl/Sql
7. Functions in Pl/Sql
8. Triggers in Pl/Sql
9. Packages in Pl/Sql
10. Pl/Sql Collections

Mastering PL/SQL Through Illustrations

eBook Preview

Author Details

BPB Publications

BPB Publications

BPB is Asia's largest publishers of Computer & IT books. For the last 63 years BPB has been a friend, philosopher and guide for programmers, developers, hardware technicians, IT Professionals who have made things happen in the IT World.

Our students work
with the Best

Related eBooks

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us