Cantitate/Preț
Produs

Oracle Database 12c PL/SQL Programming

Autor Michael McLaughlin
en Limba Engleză Paperback – 16 feb 2014

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
Citește tot Restrânge

Preț: 44340 lei

Preț vechi: 60423 lei
-27% Nou

Puncte Express: 665

Preț estimativ în valută:
8486 8815$ 7049£

Carte tipărită la comandă

Livrare economică 31 ianuarie-11 februarie 25

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9780071812436
ISBN-10: 0071812431
Pagini: 1192
Dimensiuni: 188 x 226 x 66 mm
Greutate: 1.92 kg
Editura: McGraw Hill Education
Colecția McGraw-Hill
Locul publicării:United States

Cuprins

Updated TOC to FollowPart I: PL/SQL Fundamentals
Chapter 1. Oracle PL/SQL Overview
Chapter 2. PL/SQL Basics
Chapter 3. Language Fundamentals
Chapter 4. Control Structures
Chapter 5. Error Management
Part II: PL/SQL Programming
Chapter 6. Functions and Procedures
Chapter 7. Collections
Chapter 8. Large Objects
Chapter 9. Packages
Chapter 10. Triggers
Part III: PL/SQL Advanced Programming
Chapter 11. Dynamic SQL
Chapter 12. Intersession Communication
Chapter 13. External Procedures
Chapter 14. Object Types
Chapter 15. Java Libraries
Chapter 16. Web Application Development
Part IV: Appendixes
Appendix A. Oracle Database Administration Primer
Appendix B. Oracle Database SQL Primer
Appendix C. PHP Primer
Appendix D. Oracle Database Java Primer
Appendix E. Regular Expression Primer
Appendix F. Wrapping PL/SQL Code Primer
Appendix G. PL/SQL Hierarchical Profiler Primer
Appendix H. PL/Scope
Appendix I. PL/SQL Reserved Words and Keywords
Appendix J. PL/SQL Built-in Functions
Index

Notă biografică

Michael McLaughlin, Oracle ACE , is a professor at BYU – Idaho in the Computer Information Technology Department of the Business and Communications School. He teaches courses on CIT Management, databases and systems analysis and design. Michael is the author and co-author of numerous Oracle Press titles, including Oracle Database 11g & MySQL 5.6 Developer Handbook, Oracle Database 11g PL/SQL Programming Workbook, and many other books. Mr. McLaughlin worked at Oracle Corporation for more than eight years in Consulting, Development and Support. He left Oracle as the Senior Applications Upgrade Manager in E-Business Suite Release Engineering.


Descriere

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