Oracle PL/SQL Programming

Oracle PL/SQL Programming

4.11 - 1251 ratings - Source

Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oraclea€™s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1. Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems. Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggersIa#39;d like to recommend the following sources from Oracle and Oa#39;Reilly: Oracle Database Application Developera#39;s Guidea€”Fundamentals Chapter 4 of this Oracle manual is the definitive source of information on regular expression support inanbsp;...

Title:Oracle PL/SQL Programming
Author:Steven Feuerstein, Bill Pribyl
Publisher:"O'Reilly Media, Inc." - 2014-01-23


You Must CONTINUE and create a free account to access unlimited downloads & streaming