This book teaches PL/SQL skills through real-world labs and extensive examples. Now fully updated for the newest version of PL/SQL 21c, Elena Rakhimov covers everything from basic syntax and program control through the latest optimization and tuning enhancements. Once you've done an exercise, the author doesn't just present the answer. She also offers an in-depth discussion introducing deeper insights and modern best practices.
Author: Elena Rakhimov Publisher: Oracle Press Date: May 2023 Pages: 480 ISBN: 978-0138062835 Print: 0138062838 Audience: Developers interested in Oracle PL/SQL Level: Introductory/Intermediate Category: Database

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
For more Book Watch just click.
Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.
To have new titles included in Book Watch contact BookWatch@i-programmer.info
Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.
Machines Like Me
Author: Ian McEwan Publisher: Vintage, 2019 Pages: 304 ISBN: 978-1529111255 Print: 1529111250 Kindle: B07HR6SGQ9 Audience: General Rating: 4.5 Reviewer: Mike James A novel about a synthetic human has become so much more relevant recently and guess what - it features Alan Turing.
|
SQL Server Query Tuning and Optimization (Packt)
Author: Benjamin Nevarez Publisher: Packt Publishing Pages: 446 ISBN: 9781803242620 Print: 1803242620 Kindle: B0B42SVBFY Audience: Intermediate to advanced DBAs and developers Rating: 4.7 Reviewer: Ian Stirk
This book aims to give you the tools and knowledge to get peak performance from your que [ ... ]
| More Reviews |
|