readme.html

介绍Oracle PL SQL编程

      match.</td>
  </tr>
  <tr>
    <td><a href="Chapter8/ParameterLength.sql">ParameterLength.sql</a></td>
    <td>This script illustrates constraints on formal parameters.</td>
  </tr>
  <tr>
    <td><a href="Chapter8/parameterModes.sql">parameterModes.sql</a></td>
    <td>These procedures are used to demonstrate the behavior of IN, OUT, and
      IN OUT parameter modes.</td>
  </tr>
  <tr>
    <td height="23"><a href="Chapter8/RaiseError.sql">RaiseError.sql</a></td>
    <td>This script shows the behavior of exceptions raised within subprograms.</td>
  </tr>
  <tr>
    <td><a href="Chapter8/Random.sql">Random.sql</a></td>
    <td>This illustrates package initialization.</td>
  </tr>
  <tr>
    <td><a href="Chapter8/tables.sql">tables.sql</a></td>
    <td>This script creates the tables and data used by other examples in this
      chapter. </td>
  </tr>
  <tr>
    <td><a href="Chapter8/ThreeAuthors.sql">ThreeAuthors.sql</a></td>
    <td>This script demonstrates a function and how to call it.</td>
  </tr>
</table>
<h4><a name="CH9"></a>Chapter 9:</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter9/anonymousDependencies.sql">anonymousDependencies.sql</a></td>
    <td width="71%">This script demonstrates anonymous dependencies in packages.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/automaticInvalidation.sql">automaticInvalidation.sql</a></td>
    <td>This script demonstrates the automatic invalidation of a subprogram.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/callPP.sql">callPP.sql</a></td>
    <td>This script demonstrates call to a persistent package.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/create_temp_table.sql">create_temp_table.sql</a></td>
    <td>This script builds the temporary table.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/DefaultPragma.sql">DefaultPragma.sql</a></td>
    <td>This script demonstrates default PRAGMA instructions.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/dependencies.sql">dependencies.sql</a></td>
    <td>This script demonstrates the behavior of dependent objects.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/execute.sql">execute.sql</a></td>
    <td>This script demonstrates the behavior of the EXECUTE system privilege.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/forwardDeclarations.sql">forwardDeclarations.sql</a></td>
    <td>This script demonstrates mutually exclusive subprograms.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/invokers.sql">invokers.sql</a></td>
    <td>This script demonstrates invoker rights concepts.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/invokeRTA.sql">invokeRTA.sql</a></td>
    <td>This script demonstrates invocation of RecordThreeAuthors package.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/localError.sql">localError.sql</a></td>
    <td>This script demonstrates local subprograms must be last in the
    declaration section.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/localStored.sql">localStored.sql</a></td>
    <td>This script demonstrates a local subprogram within a stored procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/localSub.sql">localSub.sql</a></td>
    <td>This script demonstrates a local subprogram.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/OracleErrors.sql">OracleErrors.sql</a></td>
    <td>This script demonstrates the use of a pipelined table function.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/overloadedLocal.sql">overloadedLocal.sql</a></td>
    <td>This script demonstrates overloaded local procedures.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/OverloadRestrictReferences.sql">OverloadRestrictReferences.sql</a></td>
    <td>This script demonstrates overloaded packages.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/PersistPkg.sql">PersistPkg.sql</a></td>
    <td>This script demonstrates user defined package.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/PersistPkg2.sql">PersistPkg2.sql</a></td>
    <td>This script demonstrates a serially reusable package.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/RecordThreeAuthors.sql">RecordThreeAuthors.sql</a></td>
    <td>This script demonstrates a procedure with dependencies.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/recreateRTA.sql">recreateRTA.sql</a></td>
    <td>This script builes RecordThreeAuthors package.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/remoteDependencies.sql">remoteDependencies.sql</a></td>
    <td>This script demonstrates dependencies between objects in different
    databases.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/RestrictReferences.sql">RestrictReferences.sql</a></td>
    <td>This script demonstrates InventoryOps packages.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/Simple.sql">Simple.sql</a></td>
    <td>This script demonstrates data dictionary views for valid and invalid objects.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/SQLFunctions.sql">SQLFunctions.sql</a></td>
    <td>This script demonstrates how stored functions can be called from SQL.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/TableFunctions.sql">TableFunctions.sql</a></td>
    <td>This script demonstrates user defined types.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/tables.sql">tables.sql</a></td>
    <td>This script builds core objects for the demonstration scripts.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/testCallPP.sql">testCallPP.sql</a></td>
    <td>This script demonstrates sequential calls to callPP.sql.</td>
  </tr>
  <tr>
    <td><a href="Chapter9/TrustPkg.sql">TrustPkg.sql</a></td>
    <td>This script builds TrustPkg.sql.</td>
  </tr>
</table>
<h4><a name="CH10"></a>Chapter 10:</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter10/cascadeRSInsert.sql">cascadeRSInsert.sql</a></td>
    <td width="71%">This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/CheckPrice.sql">CheckPrice.sql</a></td>
    <td>This script demonstrates user defined trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/CheckPrice2.sql">CheckPrice2.sql</a></td>
    <td>This script demonstrates user defined trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createClasses.sql">createClasses.sql</a></td>
    <td>This script builds the CLASSES table.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createConnectAudit.sql">createConnectAudit.sql</a></td>
    <td>This script builds the CONNECT_AUDIT table.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createNonMutating.sql">createNonMutating.sql</a></td>
    <td>This script demonstrates user defined package and triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createObjects.sql">createObjects.sql</a></td>
    <td>This script calls several demonstration programs.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createRegisteredStudents.sql">createRegisteredStudents.sql</a></td>
    <td>This script builds the REGISTERED_STUDENTS table.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createStudents.sql">createStudents.sql</a></td>
    <td>This script builds the STUDENT table.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createTempTable.sql">createTempTable.sql</a></td>
    <td>This script builds the TEMP_TABLE table.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/createUser.sql">createUser.sql</a></td>
    <td>This script creates users for Chapter 8.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/DatabaseSchema1.sql">DatabaseSchema1.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/DatabaseSchema2.sql">DatabaseSchema2.sql</a></td>
    <td>This script demonstrates user defined trigger testing.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/firingOrder.sql">firingOrder.sql</a></td>
    <td>This script demonstrates user defined trigger sequencing.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/GenerateAuthorID.sql">GenerateAuthorID.sql</a></td>
    <td>This script demonstrates the use of :new in a trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/GenerateStudentID.sql">GenerateStudentID.sql</a></td>
    <td>This script demonstrates user defined trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/insertAcademicRecords.sql">insertAcademicRecords.sql</a></td>
    <td>This script inserts values into STUDENTS and CLASSES tables.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/InsteadBooksAuthors.sql">InsteadBooksAuthors.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/insteadOf1.sql">insteadOf1.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/insteadOf2.sql">insteadOf2.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/limitMajors.sql">limitMajors.sql</a></td>
    <td>This script demonstrates user defined non-mutating trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/LogConnects.sql">LogConnects.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/LogCreations.sql">LogCreations.sql</a></td>
    <td>This script builds DDL_CREATIONS table and SYSTEM trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/Logger.java">Logger.java</a></td>
    <td>This script demonstrates Java class called by a trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/logInventoryChanges1.sql">logInventoryChanges1.sql</a></td>
    <td>This script builds INVENTORY_AUDIT table and trigger w/predicates.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/logInventoryChanges2.sql">logInventoryChanges2.sql</a></td>
    <td>This script tests the INVENTORY trigger.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/LogPkg1.sql">LogPkg1.sql</a></td>
    <td>This script demonstrates user defined packages called from
    triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/LogPkg2.sql">LogPkg2.sql</a></td>
    <td>This script demonstrates user defined PL/SQL wrappers to a Java program.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/pseudoRecords.sql">pseudoRecords.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/samename.sql">samename.sql</a></td>
    <td>This script demonstrates user defined triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/tables.sql">tables.sql</a></td>
    <td>This script builds tables and populates them for chapter 8.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/testLogPkg.sql">testLogPkg.sql</a></td>
    <td>This script demonstrates calls PL/SQL wrappers to stored Java libraries.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/testNonMutating.sql">testNonMutating.sql</a></td>
    <td>This script tests non-mutating properties.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/testTooManyMajors.sql">testTooManyMajors.sql</a></td>
    <td>This script demonstrates a mutating violation.</td>
  </tr>
  <tr>
    <td><a href="Chapter10/UpdateCategoryStats.sql">UpdateCategoryStats.sql</a></td>
    <td>This script demonstrates a user defined triggers.</td>
  </tr>
</table>
<h4><a name="CH11"></a>Chapter 11:</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter11/create_messages_table.sql">create_messages_table.sql</a></td>
    <td width="71%">This script builds table an object for DBMS_ALERT triggers.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_messenger.sql">create_messenger.sql</a></td>
    <td>This script sends builds a package to send and receive
    messages between users.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_pipe1.sql">create_pipe1.sql</a></td>
    <td>This script deletes a pipe if it exists in the context of the current
    session, then recreates it.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_pipe2.sql">create_pipe2.sql</a></td>
    <td>This script deletes a pipe if it exists in the context of the current
    session, then recreates it.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_pipe3.sql">create_pipe3.sql</a></td>
    <td>This script deletes a pipe if it exists in the context of the current
    session, recreates it, sends a message and retrieves a message from the pipe.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_pipe4.sql">create_pipe4.sql</a></td>
    <td>This script deletes a pipe if it exists in the context of the current
    session, recreates a private pipe, sends a message and retrieves a message
    from the pipe.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_signal_trigger.sql">create_signal_trigger.sql</a></td>
    <td>This script builds a trigger DBMS_ALERT signals on events
    to the MESSAGES table.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/create_user.sql">create_user.sql</a></td>
    <td>This script verifies and defines the PLSQL user. It should be run
    as the SYSTEM user or a user that has the DBA privilege role and
    EXECUTE with grant option on DBMS_PIPE.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/next_item_type1.sql">next_item_type1.sql</a></td>
    <td>This script tests DBMS_PIPE for a private pipe.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/read_local.sql">read_local.sql</a></td>
    <td>This script uses DBMS_PIPE to write a local message to
    the implicit anonymous session pipe.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/read_local_error.sql">read_local_error.sql</a></td>
    <td>This script uses DBMS_PIPE to write a local message to
    the implicit anonymous session pipe.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/read_pipe.sql">read_pipe.sql</a></td>
    <td>This script unpacks the local buffer.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/read_pipe.sql">read_pipe.sql</a></td>
    <td>This script write three messages to a private or public
    pipe by using the DBMS_PIPE package.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/register_interest.sql">register_interest.sql</a></td>
    <td>This script registers interest in a DBMS_ALERT
    to the MESSAGES table.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/insert_message.sql">insert_message.sql</a></td>
    <td>This script inserts, updates and deletes a row, triggering
    three alerts.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/use_messenger.sql">use_messenger.sql</a></td>