en
Bøger
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 trykte sider
Copyrightindehaver
BPB Publications
Oprindeligt udgivet
2021
Har du allerede læst den? Hvad synes du om den?
👍👎

Vurderinger

  • comcon375511har delt en vurderingfor 3 år siden
    👎Spring denne over
    💩Meningsløs

Citater

  • b7462562766har citeretfor 2 år siden
    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.
  • b7462562766har citeretfor 2 år siden
    This is in contrast to the LOOP-END LOOP statement which is executed at least once.

På boghylderne

fb2epub
Træk og slip dine filer (ikke mere end 5 ad gangen)