Oracle Database 12c PL/SQL Programming

AvMichael McLaughlin

Häftad, Engelska, 2014

799 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

E-bok

1 149 kr

Beskrivning

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.

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

Produktinformation

Utgivningsdatum:2014-02-16
Mått:188 x 226 x 66 mm
Vikt:1 923 g
Format:Häftad
Språk:Engelska
Antal sidor:1 192
Förlag:McGraw-Hill Education
ISBN:9780071812436

Utforska kategorier

Mer om författaren

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

Innehållsförteckning

Updated TOC to FollowPart I: PL/SQL FundamentalsChapter 1. Oracle PL/SQL OverviewChapter 2. PL/SQL BasicsChapter 3. Language FundamentalsChapter 4. Control StructuresChapter 5. Error ManagementPart II: PL/SQL ProgrammingChapter 6. Functions and ProceduresChapter 7. CollectionsChapter 8. Large ObjectsChapter 9. PackagesChapter 10. TriggersPart III: PL/SQL Advanced ProgrammingChapter 11. Dynamic SQLChapter 12. Intersession CommunicationChapter 13. External ProceduresChapter 14. Object TypesChapter 15. Java LibrariesChapter 16. Web Application DevelopmentPart IV: AppendixesAppendix A. Oracle Database Administration PrimerAppendix B. Oracle Database SQL PrimerAppendix C. PHP PrimerAppendix D. Oracle Database Java PrimerAppendix E. Regular Expression PrimerAppendix F. Wrapping PL/SQL Code PrimerAppendix G. PL/SQL Hierarchical Profiler PrimerAppendix H. PL/ScopeAppendix I. PL/SQL Reserved Words and KeywordsAppendix J. PL/SQL Built-in FunctionsIndex