會員

Advanced Oracle PL/SQL Developer's Guide（Second Edition）

Saurabh K. Gupta 著

更新時間：2021-08-20 10:44:10

開會員，本書免費讀 >

ThisbookisforOracledevelopersresponsiblefordatabasemanagement.ReadersareexpectedtohavebasicknowledgeofOracleDatabaseandthefundamentalsofPL/SQLprogramming.Certificationaspirantscanusethisbooktopreparefor1Z0-146examinationinordertobeanOracleCertifiedProfessionalinAdvancedPL/SQL.

目錄(112章)

倒序

封面
版權頁
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Overview of PL/SQL Programming Concepts
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
Chapter 2. Oracle 12c SQL and PL/SQL New Features
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
Chapter 3. Designing PL/SQL Code
Cursor structures
Cursor variables
Implicit statement results in Oracle Database 12c
Subtypes
Summary
Practice exercise
Chapter 4. Using Collections
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
Chapter 5. Using Advanced Interface Methods
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
Chapter 6. Virtual Private Database
Oracle Database Security overview
Fine-Grained Access Control
Virtual Private Database
Virtual Private Database metadata
Oracle Database 12c Security enhancements
Summary
Practice exercise
Chapter 7. Oracle SecureFiles
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
Chapter 8. Tuning the PL/SQL Code
The PL/SQL Compiler
Native and interpreted compilation techniques
Tuning PL/SQL code
Summary
Practice exercise
Chapter 9. Result Cache
Oracle Database 11g Result Cache
SQL query Result Cache
PL/SQL Function Result Cache
OCI Client results cache
The DBMS_RESULT_CACHE package
Result cache in Real Application Clusters
Summary
Practice exercise
Chapter 10. Analyzing Profiling and Tracing PL/SQL Code
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
Chapter 11. Safeguarding PL/SQL Code against SQL injection
What is SQL injection?
Preventing SQL injection attacks
Testing the code for SQL injection flaws
Summary
Practice exercise
Chapter 12. Working with Oracle SQL Developer
An overview of SQL Developer
Getting started with SQL Developer
SQL Developer 4.0 and 4.1 New Features
Summary
Index 更新時間：2021-08-20 10:44:10

官术网_书友最值得收藏!

Advanced Oracle PL/SQL Developer's Guide（Second Edition）