readme.html

来自「Oracle 9i PL/SQL程序设计的随书源码」· HTML 代码 · 共 1,171 行 · 第 1/2 页

<dt>
<tt>ch08\tabRecord.sql</tt></dt>

<dd>
Demonstrates an index-by table of records</dd>

<dt>
<tt>ch08\tConstruct.sql</tt></dt>

<dd>
Shows the use of nested table constructors</dd>

<dt>
<tt>ch08\trim.sql</tt></dt>

<dd>
Illustrates the TRIM collection method</dd>

<dt>
<tt>ch08\typeLocation.sql</tt></dt>

<dd>
Illustrates different locations for collection types</dd>

<dt>
<tt>ch08\varray.sql</tt></dt>

<dd>
Illustrates varray declarations</dd>

<dt>
<tt>ch08\vAssign.sql</tt></dt>

<dd>
Illustrates ORA-6532 and ORA-6533 with varrays</dd>

<dt>
<tt>ch08\vConstruct.sql</tt></dt>

<dd>
Illustrates varray constructors</dd>
</dl>

<h4>
Chapter 9: Creating Subprograms and Packages</h4>

<dl>
<dt>
<tt>ch09\AddNewStudent.sql</tt></dt>

<dd>
Demonstrates a stored procedure and how to call it</dd>

<dt>
<tt>ch09\AlmostFull.sql</tt></dt>

<dd>
Demonstrates a stored function</dd>

<dt>
<tt>ch09\callANS.sql</tt></dt>

<dd>
Illustrates a call to AddNewStudent</dd>

<dt>
<tt>ch09\callCL.sql</tt></dt>

<dd>
Demonstrates a call to ClassPackage.ClassList</dd>

<dt>
<tt>ch09\callFunction.sql</tt></dt>

<dd>
Shows how to call a stored function</dd>

<dt>
<tt>ch09\CallMe.sql</tt></dt>

<dd>
Demonstrates positional and named notation</dd>

<dt>
<tt>ch09\callMT.sql</tt></dt>

<dd>
Shows some calls to ModeTest</dd>

<dt>
<tt>ch09\ClassInfo.sql</tt></dt>

<dd>
Illustrates the RETURN statement</dd>

<dt>
<tt>ch09\ClassPackage.sql</tt></dt>

<dd>
Demonstrates a package</dd>

<dt>
<tt>ch09\ClassPackage2.sql</tt></dt>

<dd>
Demonstrates a package with an extra procedure in the package body</dd>

<dt>
<tt>ch09\CopyFast.sql</tt></dt>

<dd>
Demonstrates the performance improvements of the 8<i>i</i> NOCOPY modifier</dd>

<dt>
<tt>ch09\default.sql</tt></dt>

<dd>
Illustrates default parameters</dd>

<dt>
<tt>ch09\DefaultTest.sql</tt></dt>

<dd>
Illustrates different ways of calling procedures with default parameters</dd>

<dt>
<tt>ch09\ModeTest.sql</tt></dt>

<dd>
Illustrates different parameter modes and their implications</dd>

<dt>
<tt>ch09\NoCopyTest.sql</tt></dt>

<dd>
Illustrates the behavior of the NOCOPY modifier</dd>

<dt>
<tt>ch09\noparams.sql</tt></dt>

<dd>
Illustrates store subprograms with no parameters</dd>

<dt>
<tt>ch09\objectOverload.sql</tt></dt>

<dd>
Illustrates overloaded packaged procedures by object type</dd>

<dt>
<tt>ch09\overload.sql</tt></dt>

<dd>
Illustrates overloaded packaged subprograms</dd>

<dt>
<tt>ch09\packageError.sql</tt></dt>

<dd>
Illustrates some package compile errors</dd>

<dt>
<tt>ch09\ParameterLength.sql</tt></dt>

<dd>
Illustrates the effect of constraints on formal parameters</dd>

<dt>
<tt>ch09\RaiseError.sql</tt></dt>

<dd>
Illustrates the behavior of unhandled exceptions and OUT variables</dd>

<dt>
<tt>ch09\Random.sql</tt></dt>

<dd>
Illustrates a package initialization section</dd>
</dl>

<h4>
Chapter 10: Using Subprograms and Packages</h4>

<dl>
<dt>
<tt>ch10\anonymousDependencies.sql</tt></dt>

<dd>
Illustrates dependencies between an anonymous block and package runtime
state</dd>

<dt>
<tt>ch10\callRS.sql</tt></dt>

<dd>
Illustrates calls to PersistPkg.ReadStudents</dd>

<dt>
<tt>ch10\DefaultPragma.sql</tt></dt>

<dd>
Illustrates the DEFAULT keyword of RESTRICT_REFERENCES</dd>

<dt>
<tt>ch10\dependencies.sql</tt></dt>

<dd>
Illustrates dependencies between packages and other objects</dd>

<dt>
<tt>ch10\DMLUpdate.sql</tt></dt>

<dd>
Illustrates a function which can be called from a DML statement in Oracle8i</dd>

<dt>
<tt>ch10\execute.out</tt></dt>

<dd>
Output from running <tt>execute.sql</tt></dd>

<dt>
<tt>ch10\execute.sql</tt></dt>

<dd>
Demonstrates the behavior of the EXECUTE system privilege</dd>

<dt>
<tt>ch10\forwardDeclaration.sql</tt></dt>

<dd>
Illustrates a forward delcaration</dd>

<dt>
<tt>ch10\FullName.sql</tt></dt>

<dd>
Illustrates a function which can be called from a SQL statement</dd>

<dt>
<tt>ch10\InsertTemp.sql</tt></dt>

<dd>
Function which cannot be called from a SQL statement</dd>

<dt>
<tt>ch10\invokers.out</tt></dt>

<dd>
Output from running <tt>invokers.sql</tt></dd>

<dt>
<tt>ch10\invokers.sql</tt></dt>

<dd>
Demonstrates the behavior of invoker's rights procedures</dd>

<dt>
<tt>ch10\localError.sql</tt></dt>

<dd>
Illustrates an invalid location for a local subprogram</dd>

<dt>
<tt>ch10\localStored.sql</tt></dt>

<dd>
Illustrates a local subprogram within a stored subprogram</dd>

<dt>
<tt>ch10localSub.sql</tt></dt>

<dd>
Illustrates a local subprogram in an anonymous block</dd>

<dt>
<tt>ch10\mutual.sql</tt></dt>

<dd>
Demonstrates mutually exclusive local subprograms</dd>

<dt>
<tt>ch10\Overload.sql</tt></dt>

<dd>
Demonstrates RESTRICT_REFERENCES with overloaded subprograms</dd>

<dt>
<tt>ch10\overloadedLocal.sql</tt></dt>

<dd>
Shows overloaded local subprograms</dd>

<dt>
<tt>ch10\PersistPkg.sql</tt></dt>

<dd>
Illustrates the persistance of packaged variables</dd>

<dt>
<tt>ch10\PersistPkg2.sql</tt></dt>

<dd>
Serially reusable version of <tt>PersistPkg</tt></dd>

<dt>
<tt>ch10\RecordFullClasses.sql</tt></dt>

<dd>
This procedure illustrates dependencies among stored objects</dd>

<dt>
<tt>ch10\remoteDependencies.sql</tt></dt>

<dd>
Illustrates dependencies between objects in different databases</dd>

<dt>
<tt>ch10\StudentOps.sql</tt></dt>

<dd>
Package which uses the RESTRICT_REFERENCES pragma</dd>

<dt>
<tt>ch10\StudentOps2.sql</tt></dt>

<dd>
<tt>StudentOps</tt> package without the pragma</dd>

<dt>
<tt>ch10\TrustPkg.sql</tt></dt>

<dd>
Illustrates the TRUST keyword with RESTRICT_REFERENCES</dd>
</dl>

<h4>
Chapter 11: Database Triggers</h4>

<dl>
<dt>
<tt>ch11\CascadeRSInserts.sql</tt></dt>

<dd>
Implements an INSERT CASCADE</dd>

<dt>
<tt>ch11\ClassesRoomsInstead.sql</tt></dt>

<dd>
Illustrates a complete instead-of trigger</dd>

<dt>
<tt>ch11\DatabaseSchema.sql</tt></dt>

<dd>
Demonstrates database and schema system triggers</dd>

<dt>
<tt>ch11\firingOrder.sql</tt></dt>

<dd>
Demonstrates the order of DML trigger firing</dd>

<dt>
<tt>ch11\GenerateStudentID.sql</tt></dt>

<dd>
Demonstrates the :new correlation ID</dd>

<dt>
<tt>ch11\insteadOf.sql</tt></dt>

<dd>
An example of an Oracle8 instead-of trigger</dd>

<dt>
<tt>ch11\LimitMajors.sql</tt></dt>

<dd>
Illustrates the ORA-4091 mutating table error</dd>

<dt>
<tt>ch11\LogConnects.sql</tt></dt>

<dd>
Illustrates the 8<i>i</i> CALL trigger syntax</dd>

<dt>
<tt>ch11\LogCreations.sql</tt></dt>

<dd>
An example of an Oracle8<i>i</i> system trigger</dd>

<dt>
<tt>ch11\LogErrors.sql</tt></dt>

<dd>
Demonstrates a SERVERERROR trigger</dd>

<dt>
<tt>ch11\Logger.java</tt></dt>

<dd>
Java code for <tt>LogPkg2</tt></dd>

<dt>
<tt>ch11\LogPkg1.sql</tt></dt>

<dd>
PL/SQL package which logs connects and disconnects</dd>

<dt>
<tt>ch11\LogPkg2.sql</tt></dt>

<dd>
Same as <tt>LogPkg1</tt>, with the package body in Java</dd>

<dt>
<tt>ch11\LogRSChanges.sql</tt></dt>

<dd>
Illustrates trigger predicates</dd>

<dt>
<tt>ch11\mutating.sql</tt></dt>

<dd>
Demonstrates a solutation to the ORA-4091 mutating table error</dd>

<dt>
<tt>ch11\pseudoRecords.sql</tt></dt>

<dd>
Shows that <tt>:old</tt> and <tt>:new</tt> are pseudo-records</dd>

<dt>
<tt>ch11\samename.sql</tt></dt>

<dd>
Illustrates trigger namespaces</dd>

<dt>
<tt>ch11\UpdateMajorStats.sql</tt></dt>

<dd>
An example of a DML trigger</dd>
</dl>

<h4>
Chapter 12: Advanced Features</h4>

<dl>
<dt>
<tt>ch12\AlertReceive.sql</tt></dt>

<dd>
Illustrates receiving an alert using DBMS_ALERT</dd>

<dt>
ch12\AlertSend.sql</dt>

<dd>
Illustrates sending an alert through DBMS_ALERT.</dd>

<dt>
<tt>ch12\BULK_COLLECT.sql</tt></dt>

<dd>
Illustrates several different BULK_COLLECT statements</dd>

<dt>
<tt>ch12\DBMS_JOB.sql</tt></dt>

<dd>
Illustrates the DBMS_JOB package</dd>

<dt>
<tt>ch12\DBMS_LOB.sql</tt></dt>

<dd>
Illustrates the DBMS_LOB package</dd>

<dt>
<tt>ch12\dynamicDML.sql</tt></dt>

<dd>
Demonstrates the DBMS_SQL package</dd>

<dt>
<tt>ch12\execBind.sql</tt></dt>

<dd>
Demonstrates the use of the USING clause with EXECUTE IMMEDIATE to handle
bind variables</dd>

<dt>
<tt>ch12\execImmediate.sql</tt></dt>

<dd>
Demonstrates several EXECUTE IMMEDIATE commands</dd>

<dt>
<tt>ch12\FORALL.sql</tt></dt>

<dd>
Demonstrates several different FORALL statements</dd>

<dt>
<tt>ch12\LOB_DML.sql</tt></dt>

<dd>
Illustrates some LOB manipulations using DML statements</dd>

<dt>
<tt>ch12\NativeDynamic.sql</tt></dt>

<dd>
Illustrates the use of native dynamic SQL to process queries</dd>

<dt>
<tt>ch12\pipelined.sql</tt></dt>

<dd>
An example of a pipelined table function</dd>

<dt>
<tt>ch12\PipeReceive.sql</tt></dt>

<dd>
Illustrates the use of the DBMS_PIPE package to receive a message</dd>

<dt>
<tt>ch12\PipeSend.sql</tt></dt>

<dd>
Illustrates the use of the DBMS_PIPE package to send a message</dd>

<dt>
<tt>ch12\Point.sql</tt></dt>

<dd>
An example of an object type</dd>

<dt>
<tt>ch12\PointSQL.sql</tt></dt>

<dd>
This script demonstrates SQL operations on object types</dd>

<dt>
<tt>ch12\UTL_FILE.sql</tt></dt>

<dd>
Demonstrates the use of the UTL_FILE package</dd>

<dt>
<tt>ch12\UTL_HTTP.sql</tt></dt>

<dd>
Shows the use of the UTL_HTTP package</dd>

<dt>
<tt>ch12\UTL_INADDR.sql</tt></dt>

<dd>
Illustrates the use of the UTL_INADDR package</dd>

<dt>
<tt>ch12\UTL_SMTP.sql</tt></dt>

<dd>
Demonstrates the UTL_SMTP package</dd>

<dt>
<tt>ch12\UTL_TCP.sql</tt></dt>

<dd>
Shows the UTL_TCP package</dd>
</dl>

</body>
</html>