Oracle PL/SQL by Example, 6th Edition

Oracle PL/SQL by Example, 6th Edition

eBook Details:

  • Paperback: 480 pages
  • Publisher: WOW! eBook (May 21, 2023)
  • Language: English
  • ISBN-10: 0138062838
  • ISBN-13: 978-0138062835

eBook Description:

Oracle PL/SQL by Example, 6th Edition

Using PL/SQL for Oracle Database 21c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle PL/SQL by Example, 6th Edition, teaches all the PL/SQL skills you’ll need, through real-world labs and extensive examples. Now fully updated for the newest version of PL/SQL 21c, it covers everything from basic syntax and program control through the latest optimization and tuning enhancements.

New in this Oracle PL/SQL by Example, 6th Edition:

  • Updated code examples throughout
  • New iteration controls for the FOR LOOP statement, such as stepped range, multiple iterations, collection, and cursor iterations
  • Enhancements for PL/SQL qualified expressions
  • Performance enhancements for PL/SQL functions, such as SQL macro, and better control of the result cache

Other topics covered:

  • Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL’s role in PL/SQL
  • Using conditional and iterative program controls
  • Efficiently handling errors and exceptions
  • Working with cursors and triggers, including compound triggers
  • Using stored procedures, functions, and packages to write modular code that other programs can run
  • Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features

Step by step, you’ll walk through every key task, mastering today’s most valuable Oracle 21c PL/SQL programming techniques on your own. This book’s approach fully reflects the author’s award-winning experience teaching PL/SQL to professionals at Columbia University in New York City. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 21c solutions reference.

Natural Herbal Hemorrhoids Spray


Leave a Reply

Your email address will not be published. Required fields are marked *