Get Free Shipping on orders over $79
Oracle PL/SQL by Example : Prentice Hall Professional Oracle - Benjamin Rosenzweig

Oracle PL/SQL by Example

By: Benjamin Rosenzweig, Elena Rakhimov

Paperback | 24 February 2015 | Edition Number 5

At a Glance
New Edition

Paperback


RRP $88.15

$74.75

15%OFF

or 4 interest-free payments of $18.69 with

 or 

Available for Backorder. We will order this from our supplier however there isn't a current ETA.

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle(R) PL/SQL by Example, Fifth Edition, teaches all the PL/SQL skills you'll need, through real-world labs, extensive examples, exercises, and projects. Now fully updated for the newest version of PL/SQL, it covers everything from basic syntax and program control through the latest optimization and security enhancements. Step by step, you'll walk through every key task, mastering today's most valuable Oracle 12cPL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once you've done an exercise, the authors don't just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices. This book's approach fully reflects the authors' award-winning experience teaching PL/SQL to professionals at Columbia University. 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 12csolutions reference. New in This Edition
  • Updated code examples throughout
  • Result-caching of invoker's right functions for better performance
  • Extended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBC
  • Security enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns
Other topics covered
  • Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL's role in PL/SQL
  • Using conditional and iterative program control, including CONTINUE and CONTINUE WHEN
  • 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

More in Databases

Python All-in-One For Dummies : 3rd Edition - John C. Shovic

RRP $74.95

$55.75

26%
OFF
Database Systems : A Practical Approach - Mitchell Penn
Tools and Applications of Data Mining - Richard Vincent
Big Data Analytics : A Practical Guide - Candy Walken
The Data Science and Psychology - Alisha Attella
Mindf*ck : Inside Cambridge Analytica's Plot to Break the World - Profile Books
Microsoft 365 Access For Dummies : Access for Dummies - Laurie A. Ulrich
Social Research Methods : 4th Edition - Maggie Walter

RRP $101.95

$87.75

14%
OFF
Data Analytics for Accounting ISE : 3rd Edition - Vernon Richardson

RRP $169.95

$146.75

14%
OFF
Microsoft Power BI For Dummies : For Dummies (Computer/Tech) - Jack A. Hyman