![Oracle PL/SQL by Example : Oracle PL/SQL by Exam_p5 - Benjamin Rosenzweig](https://www.booktopia.com.au/covers/big/9780133798531/1221/oracle-pl-sql-by-example.jpg)
Oracle PL/SQL by Example
Oracle PL/SQL by Exam_p5
By: Benjamin Rosenzweig, Elena Rakhimov
eBook | 10 February 2015 | Edition Number 5
At a Glance
ePUB
eBook
RRP $71.95
$64.99
10%OFF
or 4 interest-free payments of $16.25 with
Instant Digital Delivery to your Booktopia Reader App
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
on
ISBN: 9780133798531
ISBN-10: 0133798534
Series: Prentice Hall Professional Oracle Series
Published: 10th February 2015
Format: ePUB
Language: English
Publisher: Pearson Education
Edition Number: 5
You Can Find This eBook In
![China's Megatrends : The 8 Pillars of a New Society - John Naisbitt](https://www.booktopia.com.au/covers/200/9780061963445/7608/china-s-megatrends.jpg)
eBOOK
RRP $24.19
$19.99
OFF
![Data Rules : Reinventing the Market Economy - Cristina Alaimo](https://www.booktopia.com.au/covers/200/9780262378437/8409/data-rules.jpg)
eBOOK
RRP $66.01
$52.99
OFF
![Data Governance Handbook : A practical approach to building trust in data - Wendy S. Batchelder](https://www.booktopia.com.au/covers/200/9781803242477/6808/data-governance-handbook.jpg)
eBOOK
RRP $61.59
$55.99
![Android Malware Detection and Adversarial Methods - Weina Niu](https://www.booktopia.com.au/covers/200/9789819714599/1010/android-malware-detection-and-adversarial-methods.jpg)
eBOOK
RRP $249.00
$224.99
OFF
![Advanced Computing and Intelligent Technologies : Proceedings of ICACIT 2023 - Rabindra Nath Shaw](https://www.booktopia.com.au/covers/200/9789819719617/4010/advanced-computing-and-intelligent-technologies.jpg)
eBOOK
RRP $369.00
$332.99
OFF
![Multiobjective Optimization Algorithms for Bioinformatics - Anirban Mukhopadhyay](https://www.booktopia.com.au/covers/200/9789819716319/4010/multiobjective-optimization-algorithms-for-bioinformatics.jpg)
eBOOK
RRP $249.00
$224.99
OFF
![Data Science and Security : Proceedings of IDSCS 2023 - Samiksha Shukla](https://www.booktopia.com.au/covers/200/9789819709755/3808/data-science-and-security.jpg)
eBOOK
RRP $349.00
$314.99
OFF
![Recommender Systems : Frontiers and Practices - Dongsheng Li](https://www.booktopia.com.au/covers/200/9789819989645/3724/recommender-systems.jpg)
eBOOK
RRP $89.99
$81.99
![Global COVID-19 Research and Modeling : A Historical Record - Longbing Cao](https://www.booktopia.com.au/covers/200/9789819999156/8323/global-covid-19-research-and-modeling.jpg)
eBOOK
RRP $319.00
$287.99
OFF
![Proceedings of International Joint Conference on Advances in Computational Intelligence : IJCACI 2023 - Mohammad Shorif Uddin](https://www.booktopia.com.au/covers/200/9789819701803/8018/proceedings-of-international-joint-conference-on-advances-in-computational-intelligence.jpg)
eBOOK
eBook
RRP $449.00
$404.99
OFF
![Advances in Tourism, Technology and Systems : Selected Papers from ICOTTS 2023, Volume 1 - António Abreu](https://www.booktopia.com.au/covers/200/9789819997657/3025/advances-in-tourism-technology-and-systems.jpg)
eBOOK
RRP $399.00
$359.99
OFF