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 Adobe Premiere Pro CC Classroom in a Book (2019 Release) by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Fight the Fear by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book The Power of Infographics by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Europe's Financial Crisis by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Great Questions by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Sams Teach Yourself Wikipedia in 10 Minutes by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book The Photoshop Elements 5 Book for Digital Photographers by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Brilliant Pitch by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Inside Microsoft Dynamics AX 2012 by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book From Still to Motion by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Continuous Integration by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book How to Craft a Disruptive Hypothesis by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Airbus' Overstretched Supply Chain by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book OS X Mavericks on Demand by Benjamin Rosenzweig, Elena Rakhimov
Cover of the book Adobe Flex 4.5 Fundamentals 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