Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing Efficient PL/SQL Blocks

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.
355 printed pages
Copyright owner
BPB Publications
Original publication
Have you already read it? How did you like it?


  • comcon375511shared an impression2 years ago
    👎Give This a Miss
    💩Utter Crap


  • b7462562766has quotedlast year
    Simple loops
    WHILE loops
    Numeric FOR loops
    Illustrative PL/SQL blocks/codes using database tables
    In simple loops, a set of statements enclosed between LOOP and END LOOP are executed repeatedly until a stopping condition is provided. WHILE loops execute a set of statements while a condition is TRUE and FOR loops help in executing a set of statements fixed number of times. However, when the number of iterations is not known, the WHILE loop is preferable. PL/SQL provides two kinds of FOR loops viz. Numeric For loops and CURSOR FOR loops. Cursor For loops will be discussed in the next chapter.
  • b7462562766has quotedlast year
    This is in contrast to the LOOP-END LOOP statement which is executed at least once.

On the bookshelves

Drag & drop your files (not more than 5 at once)