Oracle Database 11g PL / SQL Programming by Michael McLaughlin

By Michael McLaughlin

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL functions with professional information from an Oracle programming specialist. With complete insurance of the most recent positive aspects and instruments, Oracle Database 11g PL/SQL Programming lays out every one subject along designated reasons, cut-and-paste syntax examples, and real-world case experiences. entry and alter database info, build strong PL/SQL statements, execute powerful queries, and set up bulletproof protection. you are going to additionally tips on how to enforce C, C++, and Java strategies, Web-enable your database, minimize improvement time, and optimize performance.

  • Create, debug, and deal with Oracle-driven PL/SQL programs
  • Use PL/SQL constructions, delimiters, operators, variables, and statements
  • Identify and put off blunders utilizing PLSQL_WARNINGS and exception handlers
  • Work with services, tactics, programs, collections, and triggers
  • Define and set up varray, nested desk, and associative array information types
  • Handle exterior exercises, item kinds, huge items, and safe files
  • Communicate among parallel periods utilizing DBMS_ALERT and DBMS_PIPE
  • Call exterior tactics via Oracle internet providers and PL/SQL wrappers
  • Integrate inner and server-side Java type libraries utilizing Oracle JVM
  • Develop strong net purposes utilizing PL/SQL Gateway and net Toolkit

Show description

Read or Download Oracle Database 11g PL / SQL Programming PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time details entry and knowledge sharing throughout your disbursed framework utilizing the professional details during this Oracle Press consultant. Oracle Streams 11g information Replication explains how one can manage and administer a unified firm info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software exhibit four Recipes presents an example-based method of studying software show - the ground-breaking, quick software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a great instance or to kick commence their pondering and get pointed within the correct path.

Extra info for Oracle Database 11g PL / SQL Programming

Sample text

Prior to this release you would leverage shared server processes or a multithreaded Java Servlet. The multiprocess connection pool significantly reduces the memory footprint on the database tier, and it boosts the scalability of both the middle and database tiers. 4MB of real memory; 4MB is allotted for the physical connection and 400KB for the user session. 2GB of real memory. A shared-server model is more scalable and requires only 600MB of real memory for the same number of concurrent users.

The RESULT_CACHE clause indicates a function is cached only once in the SGA and available across sessions. It is new in the Oracle 11g Database. Cross-session functions only work with IN mode formal parameters. Chapter 6 contains the implementation details about these clauses. It also provides examples that demonstrate how to use them. The following illustrates a named-block procedure prototype: PROCEDURE procedure_name ( parameter1 [IN][OUT] [NOCOPY] sql_data_type | plsql_data_type , parameter2 [IN][OUT] [NOCOPY] sql_data_type | plsql_data_type , parameter(n+1) [IN][OUT] [NOCOPY] sql_data_type | plsql_data_type ) [ AUTHID {DEFINER | CURRENT_USER}] declaration_statements BEGIN execution_statements [EXCEPTION] exception_handling_statements END; / Chapter 6 discusses the rules governing procedures.

Appendix E discusses, reviews, and demonstrates regular expressions using the Oracle 11g Database regular expression functions. Quoting Alternative Beginning with Oracle 10g Release 1, the database now lets you replace the familiar single quote with another quoting symbol. This is helpful when you’ve got a bunch of apostrophes in a string that would individually require back-quoting with another single quote. )' AS phrase FROM dual; Both of these produce the following output: PHRASE -----------------------------------------------It's a bird, no plane, no it can't be ice cream!

Download PDF sample

Rated 4.56 of 5 – based on 12 votes