bookmate game
en
Books
Chandra

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 бумажных страниц
Правообладатель
BPB Publications
Дата публикации оригинала
2021
Издательство
BPB Publications
Уже прочитали? Что скажете?
👍👎

Впечатления

  • comcon375511делится впечатлением3 года назад
    👎Give This a Miss
    💩Utter Crap

Цитаты

  • b7462562766цитирует2 года назад
    Simple loops
    WHILE loops
    Numeric FOR loops
    EXIT
    EXIT-WHEN
    CONTINUE
    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.
  • b7462562766цитирует2 года назад
    This is in contrast to the LOOP-END LOOP statement which is executed at least once.

На полках

fb2epub
Перетащите файлы сюда, не более 5 за один раз