Beschreibung
Using PL/SQL for Oracle Database 12 c , 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 youll 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, youll walk through every key task, mastering todays most valuable Oracle 12 c PL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once youve done an exercise, the authors dont just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices. This books 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 12 c solutions reference. New in This EditionUpdated code examples throughoutResult-caching of invokers right functions for better performanceExtended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBCSecurity enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns Other topics coveredMastering basic PL/SQL concepts and language fundamentals, and understanding SQLs role in PL/SQLUsing conditional and iterative program control, including CONTINUE and CONTINUE WHENEfficiently handling errors and exceptionsWorking with cursors and triggers, including compound triggersUsing stored procedures, functions, and packages to write modular code that other programs can runWorking with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features
Autorenporträt
Benjamin Rosenzweig is a Senior Project Manager at Misys Financial Software, where he has worked since 2002. Prior to that he was a principal consultant for more than three years at Oracle Corporation in the Custom Development Department. His computer experience ranges from creating an electronic TibetanEnglish Dictionary in Kathmandu, Nepal, to supporting presentation centers at Goldman Sachs and managing a trading system at TIAA-CREF. Benjamin has been an instructor at the Columbia University Computer Technology and Application program in New York City since 1998. In 2002 he was awarded the Outstanding Teaching Award from the Chair and Director of the CTA program. He holds a B.A. from Reed College and a certificate in database development and design from Columbia University. His previous books with Prentice Hall are Oracle Forms Developer: The Complete Video Course (2000), and Oracle Web Application Programming for PL/SQL Developers (2003). Elena Rakhimov has more than twenty years of experience in database architecture and development in a wide spectrum of enterprise and business environments ranging from non-profit organizations to Wall Street to her current position with a prominent software company where she heads up the database team. Her determination to stay hands-on notwithstanding, Elena managed to excel in the academic arena having taught relational database programming at Columbia Universitys highly esteemed Computer Technology and Applications program. She was educated in database analysis and design at Columbia University and in applied mathematics at Baku State University in Azerbaijan. She currently resides in Vancouver, Canada.
Herstellerkennzeichnung:
Pearson Studium im Verlag Pearson Benelux B.V. Zweigniederla
Sankt-Martin-Straße 82
81541 München
DE
E-Mail: buchhandel@pearson.com
