Free shipping on orders over $99
Oracle PL/SQL by Example

Oracle PL/SQL by Example

by Benjamin Rosenzweig and Elena Rakhimov
Paperback
Publication Date: 19/06/2023

Share This Book:

  $139.50
or 4 easy payments of $34.87 with
afterpay
This item qualifies your order for FREE DELIVERY

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, Sixth 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.

Step by step, you'll walk through every key task, mastering today's most valuable Oracle 21c PL/SQL programming techniques on your own. Start by downloading the supporting schema and exercises from informit.com/title/9780138062835. Once you've done an exercise, the author doesn't just present the answer: She offers an in-depth discussion introducing deeper insights and modern best practices.

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.

New in This 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
ISBN:
9780138062835
9780138062835
Category:
Database programming
Format:
Paperback
Publication Date:
19-06-2023
Language:
English
Publisher:
Pearson Education
Country of origin:
United States
Edition:
6th Edition
Dimensions (mm):
231.9x177.8x22.86mm
Weight:
0.74kg

This title is in stock with our overseas supplier and should arrive at our Sydney warehouse within 3 - 5 weeks of you placing an order.

Once received into our warehouse we will despatch it to you with a Shipping Notification which includes online tracking.

Please check the estimated delivery times below for your region, for after your order is despatched from our warehouse:

ACT Metro: 2 working days
NSW Metro: 2 working days
NSW Rural: 2-3 working days
NSW Remote: 2-5 working days
NT Metro: 3-6 working days
NT Remote: 4-10 working days
QLD Metro: 2-4 working days
QLD Rural: 2-5 working days
QLD Remote: 2-7 working days
SA Metro: 2-5 working days
SA Rural: 3-6 working days
SA Remote: 3-7 working days
TAS Metro: 3-6 working days
TAS Rural: 3-6 working days
VIC Metro: 2-3 working days
VIC Rural: 2-4 working days
VIC Remote: 2-5 working days
WA Metro: 3-6 working days
WA Rural: 4-8 working days
WA Remote: 4-12 working days

You can find this item in:

Show more Show less

Reviews

Be the first to review Oracle PL/SQL by Example.