By Steven Feuerstein
This publication is the definitive reference on PL/SQL, thought of through the database neighborhood to be the simplest Oracle programming e-book on hand. Like its predecessors, this 5th version of Oracle PL/SQL Programming covers language basics, complex coding options, and top practices for utilizing Oracle's robust procedural language. completely up-to-date for Oracle Database 11g liberate 2, this variation unearths new PL/SQL positive factors and gives vast code samples, starting from basic examples to advanced and entire functions, within the ebook and at the spouse website.
This imperative reference for either rookies and skilled Oracle programmers can assist you:
- Get PL/SQL courses up and working quick, with transparent directions for executing, tracing, checking out, debugging, and dealing with PL/SQL code
- Optimize PL/SQL functionality as a result of a brand-new bankruptcy within the 5th edition
- Explore datatypes, conditional and sequential regulate statements, loops, exception dealing with, safety features, globalization and localization matters, and the PL/SQL architecture
- Understand and use new Oracle Database 11g positive factors, together with the edition-based redefinition potential, the functionality consequence cache, the hot proceed assertion, fine-grained dependency monitoring, sequences in PL/SQL expressions, supertype invocation from subtypes, and improvements to local compilation, triggers, and dynamic SQL
- Use new Oracle Database 11g instruments and methods similar to PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles expertise for giant objects
- Build modular PL/SQL functions utilizing tactics, features, triggers, and packages
Read or Download Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide) PDF
Best Sql books
Offering details for database directors and alertness builders, this ebook is a step by step advisor to studying software improvement and method administration with SQL, writing effective SQL code, and fine-tuning server functionality. The CD-ROM contains an assessment replica of SQL Server 7.
Write robust SQL statements and PL/SQL programsLearn to entry Oracle databases via SQL statements and build PL/SQL courses with suggestions from Oracle specialist, Jason fee. released via Oracle Press, Oracle Database 11g SQL explains tips to retrieve and adjust database info, use SQL Plus and SQL Developer, paintings with database items, write PL/SQL courses, and masses extra.
The former variation of this publication validated itself because the such a lot entire and comprehensible remedy of the SQL general regularly on hand. Many alterations have happened within the SQL criteria international seeing that that version was once released, even if: a tremendous new part, the Call-Level Interface (SQL/CLI), was once extra in 1995.
The necessity to deal with more and more better info volumes is one issue using the adoption of a brand new category of nonrelational “NoSQL” databases. Advocates of NoSQL databases declare they are often used to construct platforms which are extra performant, scale greater, and are more uncomplicated to software. NoSQL Distilled is a concise yet thorough advent to this swiftly rising expertise.
Extra resources for Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)