Oracle Database 11g PL/SQL Programming

AvMichael McLaughlin

Häftad, Engelska, 2008

768 kr

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

Fler format och utgåvor

E-bok

1 004 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.

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.

Create, debug, and manage Oracle-driven PL/SQL programs
Use PL/SQL structures, delimiters, operators, variables, and statements
Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
Work with functions, procedures, packages, collections, and triggers
Define and deploy varray, nested table, and associative array data types
Handle external routines, object types, large objects, and secure files
Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
Call external procedures through Oracle Net Services and PL/SQL wrappers
Integrate internal and server-side Java class libraries using Oracle JVM
Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Produktinformation

Utgivningsdatum:2008-05-16
Mått:180 x 231 x 44 mm
Vikt:1 365 g
Format:Häftad
Språk:Engelska
Antal sidor:835
Förlag:McGraw-Hill Education
ISBN:9780071494458

Utforska kategorier

Programmeringsböcker inom Data och IT

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

Part 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