Oracle PL/SQL by Example

Oracle PL/SQL by Exam_p5

Nonfiction, Computers, Programming, Programming Languages, SQL, Database Management
Cover of the book Oracle PL/SQL by Example by Benjamin Rosenzweig, Elena Rakhimov, Pearson Education
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Benjamin Rosenzweig, Elena Rakhimov ISBN: 9780133798531
Publisher: Pearson Education Publication: February 10, 2015
Imprint: Prentice Hall Language: English
Author: Benjamin Rosenzweig, Elena Rakhimov
ISBN: 9780133798531
Publisher: Pearson Education
Publication: February 10, 2015
Imprint: Prentice Hall
Language: English

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle® 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

 

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle® 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

 

Other topics covered

 

More books from Pearson Education

Cover of the book The Financial Times Guide to Investing by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book The Compassionate and Forgiving Organization by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book C++11 for Programmers by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book CCNP Security VPN 642-647 Official Cert Guide by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Sustainability in Supply Chain Management (Collection) by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book ActionScript 3.0 by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Ultimate Leadership by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book MCTS 70-640 Cert Guide by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Adobe Flash CS4 Professional on Demand by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Strategies to Learn More from Your Failures by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Computer Structure and Logic by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book The Tempest: York Notes for GCSE (9-1) by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Content Is Cash by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Practical Virtualization Solutions by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Effective SQL by Benjamin Rosenzweig, Elena Rakhimov
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy