Oracle Database 12c PL / SQL Programming
- Length: 1154 pages
- Edition: 1
- Language: English
- Publisher: McGraw-Hill Osborne Media
- Publication Date: 2014-01-24
- ISBN-10: 0071812431
- ISBN-13: 9780071812436
- Sales Rank: #148490 (See Top 100 Books)
Master Oracle Database 12c PL/SQL Application Development
Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.
- Explore new SQL and PL/SQL features in Oracle Database 12c
- Build control structures, cursors, and loop statements
- Work with collections, varrays, tables, and associative array collections
- Locate and repair errors and employ exception handlers
- Execute black box, white box, and integration tests
- Configure and manage stored packages and libraries
- Handle security with authentication and encryption
- Use LOBs to store text and multimedia content
- Write and implement PL/SQL and Java triggers
- Extend functionality using dynamic SQL statements
- Understand object types, nested tables, and unnesting queries
Table of Contents
PART I Oracle PL/SQL
Chapter 1 Oracle PL/SQL Development Overview
Chapter 2 New Features
Chapter 3 PL/SQL Basics
Chapter 4 Language Fundamentals
Chapter 5 Control Structures
Chapter 6 Collections
Chapter 7 Error Management
PART II PL/SQL Programming
Chapter 8 Functions and Procedures
Chapter 9 Packages
Chapter 10 Large Objects
Chapter 11 Object Types
Chapter 12 Triggers
Chapter 13 Dynamic SQL
PART III Appendixes and Glossary
Appendix A Oracle Database Primer
Appendix B SQL Primer
Appendix C SQL Built-in Functions
Appendix D PL/SQL Built-in Packages and Types
Appendix E Regular Expression Primer
Appendix F Wrapping PL/SQL Code Primer
Appendix G PL/SQL Hierarchical Profiler Primer
Appendix H PL/SQL Reserved Words and Keywords
Appendix I Mastery Check Answers
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.