| Description |
1 online resource : illustrations. |
|
text file rda |
| Series |
Professional experience distilled |
|
Professional experience distilled.
|
| Note |
Includes index. |
| Summary |
Annotation The OCP certification is the second milestone for the experienced associate level Oracle professionals which enhances one's credibility in work environment, and catalyzes your employment opportunities. The Packt's book Oracle Advanced PL/SQL Developer Professional Guide helps you to master the advanced PL/SQL concepts in Oracle 11g. The book aims to be a sure selection for the experienced Oracle professionals aspiring for Professional level by writing Oracle certification exam "1Z0-146: Oracle Database 11g: Advanced PL/SQL." The topics covered in the book are in line with the Oracle University prescription for 1Z0-146 certification, which justify the version updates to be advanced and not complex. The book has been reviewed by Oracle ACEs Kamran Agayev, Ronald Rood, Mohan Dutta, and Marcel Hoefs. The book covers the advanced features of PL/SQL which are required to design and optimize the PL/SQL code in database applications. The features like collections, external procedures, server side result caching, enforce row level security using VPD, handling large objects and SecureFiles build up a concrete platform for a PL/SQL professional. Apart from the programming, the book makes instrumental recommendations on the usage of development tool SQL Developer, employing best practices in database environments and safeguarding the vulnerable areas in PL/SQL code to avoid code injection. |
| Contents |
Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Overview of PL/SQL Programming Concepts; Chapter 2: Oracle 12c SQL and PL/SQL New Features; Chapter 3: Designing PL/SQL Code; Chapter 4: Using Collections; Chapter 5: Using Advanced Interface Methods; Chapter 6: Virtual Private Database; Chapter 7: Oracle SecureFiles; Chapter 8: Tuning PL/SQL Code; Chapter 9: Result Cache; Chapter 10: Analyzing, Profiling, and Tracing PL/SQL Code; Chapter 11: Safeguarding PL/SQL Code against SQL injection |
|
Chapter 12: Working with Oracle SQL DeveloperIndex; Introduction to PL/SQL; Cursors -- an overview; Exception handling in PL/SQL; Creating stored procedures; Functions; A PL/SQL package; Oracle Database 12c enhancements to PL/SQL subprograms; Managing database dependencies; Reviewing Oracle-supplied packages; Oracle SQL Developer; Summary; Practice exercise; Database consolidation and the new Multitenant architecture; Oracle 12c SQL and PL/SQL new features; The Oracle Database 12c (12.1.0.2) In-Memory option; Summary; Cursor structures; Cursor variables |
|
Implicit statement results in Oracle Database 12cSubtypes; Summary; Practice exercise; Introduction to collections; Collection types; Associative arrays; Nested tables; Varray; Comparing the collection types; Oracle 12c enhancements to collections; PL/SQL collection methods; Summary; Practice exercise; Overview of External Procedures; Components of external procedure execution flow; Executing external C programs from PL/SQL; Securing External Procedures with Oracle Database 12c; Executing Java programs from PL/SQL; Summary; Practice exercise; Oracle Database Security overview |
|
Fine-Grained Access ControlVirtual Private Database; Virtual Private Database metadata; Oracle Database 12c Security enhancements; Summary; Practice exercise; Introduction to Large Objects; LOB data types in Oracle; Oracle SecureFiles; Working with LOBs; Migrating LONG to LOBs; Migrating BasicFiles to SecureFiles; Oracle Database 12c enhancements to SecureFiles; Summary; Practice exercise; The PL/SQL Compiler; Native and interpreted compilation techniques; Tuning PL/SQL code; Summary; Practice exercise; Oracle Database 11g Result Cache; SQL query Result Cache; PL/SQL Function Result Cache |
|
OCI Client results cacheThe DBMS_RESULT_CACHE package; Result cache in Real Application Clusters; Summary; Practice exercise; A sample PL/SQL program; Tracking PL/SQL coding information; Determining identifier types and usages; The DBMS_METADATA package; Tracing PL/SQL programs using DBMS_TRACE; Profiling PL/SQL code; Summary; Practice exercise; What is SQL injection?; Preventing SQL injection attacks; Testing the code for SQL injection flaws; Summary; Practice exercise; An overview of SQL Developer; Getting started with SQL Developer; SQL Developer 4.0 and 4.1 New Features; Summary |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
PL/SQL (Computer program language)
|
|
Java (Computer program language)
|
|
Database design.
|
|
Database management.
|
|
PL/SQL (Langage de programmation) |
|
Java (Langage de programmation) |
|
Bases de données -- Conception. |
|
Bases de données -- Gestion. |
|
Database design |
|
Database management |
|
Java (Computer program language) |
|
PL/SQL (Computer program language) |
| Other Form: |
Erscheint auch als: Druck-Ausgabe |
| ISBN |
9781785282522 electronic bk. |
|
1785282522 electronic bk. |
|
More Resources