舉報 
會員
Advanced Oracle PL/SQL Developer's Guide（Second Edition）
最新章節：
Index
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
推薦閱讀
- C++ Primer習題集（第5版）
- Google Flutter Mobile Development Quick Start Guide
- 信息可視化的藝術：信息可視化在英國
- MongoDB for Java Developers
- Django開發從入門到實踐
- Instant 960 Grid System
- 21天學通C++（第6版）
- 精通Python自然語言處理
- Python機器學習編程與實戰
- PLC編程與調試技術（松下系列）
- Unreal Engine 4 Shaders and Effects Cookbook
- Asynchronous Android Programming（Second Edition）
- Integrating Facebook iOS SDK with Your Application
- Python Data Structures and Algorithms
- RESTful Java Web Services（Second Edition）
- Hands-On Nuxt.js Web Development
- Application Development with Parse using iOS SDK
- Secret Recipes of the Python Ninja
- 從零開始學Python大數據與量化交易
- Java RESTful Web Service實戰
- Mastering Python
- Python編程：從入門到實踐（第2版）
- C++ Windows Programming
- 計算機網絡基礎
- Kivy Blueprints
- Developing Responsive Web Applications with AJAX and jQuery
- Drush for Developers（Second Edition）
- Building Web and Mobile ArcGIS Server Applications with JavaScript
- Practical Data Analysis（Second Edition）
- Scratch 3.0少兒游戲趣味編程2
