From Learning Fundamentals to Developing Efficient PL/SQL Blocks
This is the code repository for Mastering PL/SQL Through Illustrations , published by BPB Publications. It contains all the supporting project files necessary to work through the journey of this book
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.
- 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.