readme.html

介绍Oracle PL SQL编程

    <td>This script demonstrates MESSENGER as a wrapper for the
    DBMS_PIPE package.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/waitone.sql">waitone.sql</a></td>
    <td>This script waits for a DBMS_ALERT alert, which is
    triggered on DML to the MESSAGES table.</td>
  </tr>
  <tr>
    <td><a href="Chapter11/write_local.sql">write_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/write_pipe.sql">write_pipe.sql</a></td>
    <td>This script write three messages to a private or public
    pipe by using the DBMS_PIPE package.</td>
  </tr>
</table>
<h4><a name="CH12"></a>Chapter 12:</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter12/create_javalib1.sql">create_javalib1.sql</a></td>
    <td width="71%">This script demonstrates how to build a Java library wrapper.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/create_library1.sql">create_library1.sql</a></td>
    <td>This script demonstrates how to create a library for an external procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/create_library2.sql">create_library2.sql</a></td>
    <td>This script demonstrates how to create a library for
    an external procedure for a poorly C program that
    fails to match the signature of the PL/SQL library.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/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="Chapter12/listener1.ora">listener1.ora</a></td>
    <td>Standard single listener shell for listener.ora file.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/listener2.ora">listener2.ora</a></td>
    <td>Standard two listener shell for listener.ora file.
    The extproc IPC listener is separated.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/listener3.ora">listener3.ora</a></td>
    <td>Standard two listener shell for listener.ora file.
    The extproc IPC listener is separated and ENV accesses
    multiple DDL paths</td>
  </tr>
  <tr>
    <td><a href="Chapter12/ReadFile1.java">ReadFile1.java</a></td>
    <td>This script demonstrates how to read a file in Java.
    It is designed as a Java library file for an Oracle
    database stored library.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/tnsnames1.ora">tnsnames1.ora</a></td>
    <td>Standard single listener shell for tnsnames.ora file.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/tnsnames2.ora">tnsnames2.ora</a></td>
    <td>Standard two listener shell for tnsnames.ora file.
    The extproc IPC listener is separated.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/tnsnames3.ora">tnsnames3.ora</a></td>
    <td>Standard two listener shell for tnsnames.ora file.
    The extproc IPC listener is separated.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/writestr1.c">writestr1.c</a></td>
    <td>This script opens a file and write a single line
    of text to the file. It is used in conjunction
    with the create_library1.sql script.</td>
  </tr>
  <tr>
    <td><a href="Chapter12/writestr2.c">writestr2.c</a></td>
    <td>This script opens a file and write a single line
    of text to the file. It is used in conjunction
    with the create_library2.sql script.</td>
  </tr>
</table>
<h4><a name="CH13"></a>Chapter 13:</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter13/create_types.sql">create_types.sql</a></td>
    <td width="71%">This is build types to test the Native Dynamic SQL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/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. It also has grants needed
    by the DMBS_SQL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/dbms_sql.sql">dbms_sql.sql</a></td>
    <td>This is designed as a working tutorial of the Oracle
    Built-in DBMS_SQL with examples of the for key methods.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/dbms_sql_01.sql">dbms_sql_01.sql</a></td>
    <td>This is designed to test the DBMS_SQL_TUTORIAL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/dbms_sql_02.sql">dbms_sql_02.sql</a></td>
    <td>This is designed to test the DBMS_SQL_TUTORIAL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/dbms_sql_03.sql">dbms_sql_03.sql</a></td>
    <td>This is designed to test the DBMS_SQL_TUTORIAL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/nds_null.sql">nds_null.sql</a></td>
    <td>This is designed to demonstrate managing a null value.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/nds_sql_01.sql">nds_sql_01.sql</a></td>
    <td>This is designed to test the Native Dynamic SQL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/nds_sql_02.sql">nds_sql_02.sql</a></td>
    <td>This is designed to test the Native Dynamic SQL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/nds_sql_03.sql">nds_sql_03.sql</a></td>
    <td>This is designed to test the Native Dynamic SQL package.</td>
  </tr>
  <tr>
    <td><a href="Chapter13/nds_sqle.sql">nds_sqle.sql</a></td>
    <td>This is designed as a working tutorial of the Oracle
    Native Dynamic SQL (NDS) with an error in an OUT mode
    parameter. It will compile successfully and raise a
    runtime exception.</td>
  </tr>
</table>
<h4><a name="CH14"></a>Chapter 14: Introduction to Objects</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter14/CreateUser.sql">CreateUser.sql</a></td>
    <td width="71%">This script creates the plsql user for chapter 14 examples.
      You must run this script as SYS or SYSTEM as SYSDBA. The script can be rerun.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/AttributeChain.sql">AttributeChain.sql</a></td>
    <td>This script demonstrates attribute chaining.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/ComplexObj.sql">ComplexObj.sql</a></td>
    <td>This script demonstrates complex objects.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/ConstructorMethod.sql">ConstructorMethod.sql</a></td>
    <td>This script demonstrates the user-defined constructor method.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/DynamicDispatch.sql">DynamicDispatch.sql</a></td>
    <td>This script demonstrates dynamic dispatch/dynamic polymorphism.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/Inheritance.sql">Inheritance.sql</a></td>
    <td>This script demonstrates object type inheritance.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/MapMethod.sql">MapMethod.sql</a></td>
    <td>This script demonstrates the map method.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/MemberMethod.sql">MemberMethod.sql</a></td>
    <td>This script demonstrates the member method.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/ObjInit.sql">ObjInit.sql</a></td>
    <td>This script demonstrates object initialization.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/OrderMethod.sql">OrderMethod.sql</a></td>
    <td>This script demonstrates the order method.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/StaticMethod.sql">StaticMethod.sql</a></td>
    <td>This script demonstrates the static method.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/TypeAttribute.sql">TypeAttribute.sql</a></td>
    <td>This script demonstrates the use of %TYPE.</td>
  </tr>
  <tr>
    <td><a href="Chapter14/TypeEvolution.sql">TypeEvolution.sql</a></td>
    <td>This script demonstrates type evolution for object maintenance.</td>
  </tr>
</table>
<h4><a name="CH15"></a>Chapter 15: Objects in the Database</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter15/CreateUser.sql">CreateUser.sql</a></td>
    <td width="71%">This script creates the plsql user for chapter 15 examples.
      You must run this script as SYS or SYSTEM as SYSDBA. The script can be rerun.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/AttributeChain.sql">AttributeChain.sql</a></td>
    <td>This script demonstrates attribute chaining.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/ColObj.sql">ColObj.sql</a></td>
    <td>This script demonstrates column objects.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/ForwardDeclaration.sql">ForwardDeclaration.sql</a></td>
    <td>This script demonstrates forward type declarations.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/Inheritance.sql">Inheritance.sql</a></td>
    <td>This script demonstrates object type inheritance.</td>
  </tr>
  <tr>
    <td height="23"><a href="Chapter15/IsDangling.sql">IsDangling.sql</a></td>
    <td>This script demonstrates how to handle dangling REFs.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/IsOf.sql">IsOf.sql</a></td>
    <td>This script demonstrates the IS OF type statement.</td>
  </tr>
  <tr>
    <td height="24"><a href="Chapter15/ObjectTable.sql">ObjectTable.sql</a></td>
    <td>This script demonstrates the creation of an object table, and includes
      an anonymous block to demonstrate DML operations against an object table.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/ObjectView.sql">ObjectView.sql</a></td>
    <td>This script demonstrates object view creation.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/ObjMaintain.sql">ObjMaintain.sql</a></td>
    <td>This script demonstrates type evolution.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/RefObj.sql">RefObj.sql</a></td>
    <td>This script demonstrates object references using REF.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/Treat.sql">Treat.sql</a></td>
    <td>This script demonstrates the TREAT function.</td>
  </tr>
  <tr>
    <td><a href="Chapter15/UtlRef.sql">UtlRef.sql</a></td>
    <td>This script demonstrates the UTL_REF package.</td>
  </tr>
</table>
<h4><a name="CH16"></a>Chapter 16: Large Objects</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter16/CreateUser.sql">CreateUser.sql</a></td>
    <td width="71%">This script creates the plsql user for chapter 16 examples.
      You must run this script as SYS or SYSTEM as SYSDBA. The script can be rerun.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/BfileClose.sql">BfileClose.sql</a></td>
    <td>This script tests the DBMS_LOB.CLOSE procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/BfileCloseAll.sql">BfileCloseAll.sql</a></td>
    <td>This script tests the DBMS_LOB.FILECLOSEALL procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/BfileFileExists.sql">BfileFileExists.sql</a></td>
    <td>This script tests the DBMS_LOB.FILEEXISTS procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/BfileIsOpen.sql">BfileIsOpen.sql</a></td>
    <td>This script tests the DBMS_LOB.ISOPEN function.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/ClobCompare.sql">ClobCompare.sql</a></td>
    <td>This script tests the DBMS_LOB.COMPARE function.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/Convert.sql">Convert.sql</a></td>
    <td>This script tests the DBMS_LOB.CONVERTTOBLOB and DBMS_LOB.CONVERTTOCLOB
      procedures.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/CreateLobTables.sql">CreateLobTables.sql</a></td>
    <td>This script demonstrates storage options available for LOBs.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/LoadFromFile.sql">LoadFromFile.sql</a></td>
    <td>This script tests the DBMS_LOB.LOADFROMFILE procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/LoadLOBFromFile.sql">LoadLOBFromFile.sql</a></td>
    <td>This script tests the DBMS_LOB.LOADLOBFROMFILE procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/LobInsert.sql">LobInsert.sql</a></td>
    <td>This script demonstrates LOB inserts.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/LobUpdate.sql">LobUpdate.sql</a></td>
    <td>This script demonstrates LOB updates.</td>
  </tr>
  <tr>
    <td height="23"><a href="Chapter16/LongToLob.sql">LongToLob.sql</a></td>
    <td>This script demonstrates the conversion of Longs to LOBs.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/NclobAppend.sql">NCLOBAppend.sql</a></td>
    <td>This script demonstrates the DBMS_LOB.APPEND procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/Returning.sql">Returning.sql</a></td>
    <td>This script demonstrates returning clause.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/TextIndex.sql">TextIndex.sql</a></td>
    <td>This script demonstrates indexing using Oracle Text.</td>
  </tr>
  <tr>
    <td><a href="Chapter16/VarrayLob.sql">VarrayLob.sql</a></td>
    <td>This script demonstrates user-defined LOBs.</td>
  </tr>
</table>
<h4><a name="CH17"></a>Chapter 17: Scheduling Tasks</h4>
<table width="100%" border="1">
  <tr>
    <td width="29%"><a href="Chapter17/CreateUser.sql">CreateUser.sql</a></td>
    <td width="71%">This script creates the plsql user for chapter 17 examples.
      You must run this script as SYS or SYSTEM as SYSDBA. The script can be rerun.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/Broken.sql">Broken.sql</a></td>
    <td>This script tests the DBMS_JOB.BROKEN procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/Change.sql">Change.sql</a></td>
    <td>This script tests the DBMS_JOB.CHANGE procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/CreateJob.sql">CreateJob.sql</a></td>
    <td>This script tests the DBMS_SCHEDULER.CREATE_JOB procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/Remove.sql">Remove.sql</a></td>
    <td>This script tests the DBMS_JOB.REMOVE procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/Run.sql">Run.sql</a></td>
    <td>This script tests the DBMS_JOB.RUN procedure.</td>
  </tr>
  <tr>
    <td><a href="Chapter17/Submit.sql">Submit.sql</a></td>
    <td>This script tests the DBMS_JOB.SUBMIT procedure.</td>
  </tr>
</table>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>