Oracle Database 12c: PL/SQL Programming
Design and Deploy Powerful, Database-Centric PL/SQL Applications
Paperback Engels 2014 1e druk 9780071812436Samenvatting
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
Specificaties
Lezersrecensies
Inhoudsopgave
Introduction
Part I: PL/SQL
1. Oracle PL/SQL Development Overview
2. New features
3. PL/SQL Basics
4. Language Fundamentals
5. Control Structures
6 Collections
7. Error Management
Part II: PL/SQL Programming
8. Functions and Procedures
9. Packages
10. Large Objects
11. Object Types
12. Triggers
13. Dynamic SQL
Part IV: Appendixes
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
Index
Anderen die dit boek kochten, kochten ook
-
Scott Urman€ 65,30 -
William Holstein€ 30,27
-
Dieter Möckelmann€ 16,95
-
Remko van der Pols€ 49,00
-
Jeanne Boyarsky€ 59,10
-
Kim Pot€ 23,50
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan