Oracle Database 11g PL/SQL Programming
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....
Search in google:
Design Feature-Rich PL/SQL ApplicationsDeliver 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 programsUse PL/SQL structures, delimiters, operators, variables, and statementsIdentify and eliminate errors using PLSQL_WARNINGS and exception handlersWork with functions, procedures, packages, collections, and triggersDefine and deploy varray, nested table, and associative array data typesHandle external routines, object types, large objects, and secure filesCommunicate between parallel sessions using DBMS_ALERT and DBMS_PIPECall external procedures through Oracle Net Services and PL/SQL wrappersIntegrate internal and server-side Java class libraries using Oracle JVMDevelop robust Web applications using PL/SQL Gateway and Web Toolkit
Pt. I PL/SQL Fundamentals1 Oracle PL/SQL Overview 32 PL/SQL Basics 253 Language Fundamentals 454 Control Structures 915 Error Management 131Pt. II PL/SQL Programming6 Functions and Procedures 1637 Collections 2078 Large Objects 2659 Packages 31310 Triggers 343Pt. III PL/SQL Advanced Programming11 Dynamic SQL 38112 Intersession Communication 41713 External Procedures 44514 Object Types 47515 Java Libraries 50516 Web Application Development 533Pt. IV AppendixesA Oracle Database Administration Primer 571B Oracle Database SQL Primer 599C PHP Primer 629D Oracle Database Java Primer 685E Regular Expression Primer 729F Wrapping PL/SQL Code Primer 747G PL/SQL Hierarchical Profiler Primer 753H PL/Scope 765I PL/SQL Reserved Words and Keywords 769J PL/SQL Built-in Functions 777Index 821
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
