readme.html
来自「Oracle 9i PL/SQL程序设计的随书源码」· HTML 代码 · 共 1,171 行 · 第 1/2 页
HTML
1,171 行
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Mozilla/4.75 [en] (Win98; U) [Netscape]">
<title>Oracle9i PL/SQL Programming Online Examples</title>
</head>
<body>
The source code for
all of the examples in <u>Oracle9<i>i</i> PL/SQL Programming</u> can be
found in the <tt>code</tt> directory on the CD. The files for each chapter
can be found in separate directories, i.e. the examples in Chapter 1 are
found in <tt>code\ch01</tt>. In addition, there is one file, <tt>tables.sql</tt>,
in the top level <tt>code</tt> directory. This file creates the tables
used for the examples in the book. The remaining files are as follows:
<h4>
Chapter 1: Introduction</h4>
<dl>
<dt>
<tt>ch01\3gl_4gl.sql</tt></dt>
<dd>
Demonstrates both SQL and PL/SQL commands</dd>
<dt>
<tt>ch01\Collections.sql</tt></dt>
<dd>
Illustrates different types of collections</dd>
<dt>
<tt>ch01\Conditional.sql</tt></dt>
<dd>
Illustrates a conditional statement</dd>
<dt>
<tt>ch01\CursorLoop.sql</tt></dt>
<dd>
Demonstrates a cursor fetch loop</dd>
<dt>
<tt>ch01\Error.sql</tt></dt>
<dd>
Illustrates an exception handler</dd>
<dt>
<tt>ch01\NumericLoop.sql</tt></dt>
<dd>
Demonstrates a numeric FOR loop</dd>
<dt>
<tt>ch01\PrintStudents.sql</tt></dt>
<dd>
Illustrates a stored procedure</dd>
<dt>
<tt>ch01\RoomsPkg.sql</tt></dt>
<dd>
Shows a PL/SQL package</dd>
<dt>
<tt>ch01\SimpleLoop.sql</tt></dt>
<dd>
Demonstrates a simple loop</dd>
</dl>
<h4>
Chapter 2: Development and Execution Environments</h4>
<dl>
<dt>
<tt>ch02\File.sql</tt></dt>
<dd>
Sample file for execution in SQL*Plus</dd>
<dt>
<tt>ch02\Setup.sql</tt></dt>
<dd>
Sets up a sample environment for the development tools</dd>
<dt>
<tt>ch02\SimpleClass.sql</tt></dt>
<dd>
Script which creates a sample Java class</dd>
</dl>
<h4>
Chapter 3: PL/SQL Basics</h4>
<dl>
<dt>
<tt>ch03\allthree.sql</tt></dt>
<dd>
Demonstrates all three sections of a PL/SQL block</dd>
<dt>
<tt>ch03\AnonymousBlock.sql</tt></dt>
<dd>
An example of an anonymous block</dd>
<dt>
<tt>ch03\case.sql</tt></dt>
<dd>
Demonstrates the CASE statement</dd>
<dt>
<tt>ch03\comments.sql</tt></dt>
<dd>
Demonstrates legal and illegal comments</dd>
<dt>
<tt>ch03\exitwhen.sql</tt></dt>
<dd>
Illustrates the EXIT WHEN clause</dd>
<dt>
<tt>ch03\forloop.sql</tt></dt>
<dd>
An example of a FOR loop.</dd>
<dt>
<tt>ch03\forscope.sql</tt></dt>
<dd>
Demonstrates the scope of the index of a FOR LOOP</dd>
<dt>
<tt>ch03\goto.sql</tt></dt>
<dd>
Illustrates the GOTO statement.</dd>
<dt>
<tt>ch03\if1.sql</tt></dt>
<dd>
Demonstrates an IF statement</dd>
<dt>
<tt>ch03\if2.sql</tt></dt>
<dd>
The IF statement in this example contains more than one statement per condition</dd>
<dt>
<tt>ch03\integers.sql</tt></dt>
<dd>
Shows different integeter types</dd>
<dt>
<tt>ch03\LabeledBlock.sql</tt></dt>
<dd>
An example of a labeled block</dd>
<dt>
<tt>ch03\nested.sql</tt></dt>
<dd>
Illustrates 2 nested blocks</dd>
<dt>
<tt>ch03\null.sq</tt></dt>
<dd>
Illustrates NULL as a statement.</dd>
<dt>
<tt>ch03\Procedure.sql</tt></dt>
<dd>
Illustrates a PL/SQL procedure</dd>
<dt>
<tt>ch03\RecordAssignment.sql</tt></dt>
<dd>
Shows legal and illegal record assignments</dd>
<dt>
<tt>ch03\RecordSelect.sql</tt></dt>
<dd>
Shows how to select into a record</dd>
<dt>
<tt>ch03\simple.sql</tt></dt>
<dd>
An example of a simple loop</dd>
<dt>
<tt>ch03\trigger.sql</tt></dt>
<dd>
An example of a database trigger</dd>
<dt>
<tt>ch03\while1.sql</tt></dt>
<dd>
Illustrates a WHILE loop.</dd>
<dt>
<tt>ch03\while2.sql</tt></dt>
<dd>
The WHILE loop in this example has a NULL condition</dd>
</dl>
<h4>
Chapter 4: SQL Within PL/SQL</h4>
<dl>
<dt>
<tt>ch04\autoPragma.sql</tt></dt>
<dd>
Illustrates legal and illegal uses of PRAGMA AUTONOMOUS_TRANSACTION</dd>
<dt>
<tt>ch04\autoSavePoints.sql</tt></dt>
<dd>
Demonstrates the interaction between savepoints and autonomous transactions</dd>
<dt>
<tt>ch04\autoTrans.sql</tt></dt>
<dd>
Demonstrates autonomous transactions</dd>
<dt>
<tt>ch04\BindVariable.sql</tt></dt>
<dd>
illustrates the use of a bind variable</dd>
<dt>
<tt>ch04\bulkDemo.sql</tt></dt>
<dd>
illustrates bulk processing</dd>
<dt>
<tt>ch04\delete.sql</tt></dt>
<dd>
illustrates the DELETE statement</dd>
<dt>
<tt>ch04\insert.sql</tt></dt>
<dd>
shows some INSERT statements</dd>
<dt>
<tt>ch04\returning.sql</tt></dt>
<dd>
shows the RETURNING INTO clause</dd>
<dt>
<tt>ch04\select.sql</tt></dt>
<dd>
contains examples of SELECT statements</dd>
<dt>
<tt>ch04\update.sql</tt></dt>
<dd>
demonstrates some UPDATE statements</dd>
<dt>
<tt>ch04\WhereClause.sql</tt></dt>
<dd>
demonstrates several different WHERE clauses</dd>
</dl>
<h4>
Chapter 5: Built-in SQL Functions</h4>
There are no online examples for this chapter.
<h4>
Chapter 6: Cursors</h4>
<dl>
<dt>
<tt>ch06\AlreadyOpen</tt></dt>
<dd>
Illustrates the ORA-6511 error</dd>
<dt>
<tt>ch06\BadFetch</tt></dt>
<dd>
Illustrates legal and illegal FETCH statements</dd>
<dt>
<tt>ch06\commit</tt></dt>
<dd>
This example will raise "ORA-1002: fetch out of sequence" because of the
commit inside the SELECT...FOR UPDATE loop.</dd>
<dt>
<tt>ch06\cursor1.pc</tt></dt>
<dd>
This Pro*C program illustrates the use of a cursor variable.</dd>
<dt>
<tt>ch06\cursor2.sql</tt></dt>
<dd>
This procedure illustrates server-side cursor variables.</dd>
<dt>
<tt>ch06\CursorLoop.sql</tt></dt>
<dd>
Illustrates an explicit cursor fetch loop</dd>
<dt>
<tt>ch06\ExitWhen.sql</tt></dt>
<dd>
Illustrates the incorrect location of the EXIT WHEN statement</dd>
<dt>
<tt>ch06\ForLoop.sql</tt></dt>
<dd>
Demonstrates a cursor FOR loop</dd>
<dt>
<tt>ch06\ForUpdate.sql</tt></dt>
<dd>
Illustrates a cursor with a FOR UPDATE clause</dd>
<dt>
<tt>ch06\ImplicitFOR.sql</tt></dt>
<dd>
Demonstrates an implicit FOR loop</dd>
<dt>
<tt>ch06\NoDataFound.sql</tt></dt>
<dd>
Illustrates the behavior of the NO_DATA_FOUND exception</dd>
<dt>
<tt>ch06\NoMatch.sql</tt></dt>
<dd>
Iillustrates the use of cursor attributes on the implicit SQL cursor</dd>
<dt>
<tt>ch06\Parameterized.sql</tt></dt>
<dd>
Illustrates the declaration of a parameterized cursor</dd>
<dt>
<tt>ch06\RefCursors.sql</tt></dt>
<dd>
Illustrates several REF CURSOR declarations</dd>
<dt>
<tt>ch06\SimpleLoop.sql</tt></dt>
<dd>
Demonstrates a simple fetch loop</dd>
<dt>
<tt>ch06\WhileLoop.sql</tt></dt>
<dd>
Illustrates a WHILE cursor fetch loop</dd>
</dl>
<h4>
Chapter 7: Error Handling</h4>
<dl>
<dt>
<tt>ch07\DuplicateHandlers.sql</tt></dt>
<dd>
Illustrates the PLS-483 error</dd>
<dt>
<tt>ch07\DupValOnIndex.sql</tt></dt>
<dd>
This example will raise the DUP_VAL_ON_INDEX exception</dd>
<dt>
<tt>ch07\ErrorPkg.sql</tt></dt>
<dd>
Illustrates a more advanced error handling package</dd>
<dt>
<tt>ch07\ExceptionInit.sql</tt></dt>
<dd>
illustrates the EXCEPTION_INIT pragma</dd>
<dt>
<tt>ch07\NoDataFound.sql</tt></dt>
<dd>
This block will raise the NO_DATA_FOUND exception</dd>
<dt>
<tt>ch07\OutOfScope.sql</tt></dt>
<dd>
Illustrates the scope of exceptions</dd>
<dt>
<tt>ch07\Register.sql</tt></dt>
<dd>
This procedure illustrates the use of RAISE_APPLICATION_ERROR.</dd>
<dt>
<tt>ch07\SQLERRM.sql</tt></dt>
<dd>
Shows the behavior of the SQLERRM function</dd>
<dt>
<tt>ch07\UserDefined.sql</tt></dt>
<dd>
Illustrates user defined exceptions</dd>
<dt>
<tt>ch07\ValueError.sql</tt></dt>
<dd>
Raises the VALUE_ERROR exception in two different ways.</dd>
</dl>
<h4>
Chapter 8: Collections</h4>
<dl>
<dt>
<tt>ch08\callLibrary.sql</tt></dt>
<dd>
Demonstrates calls to the Library package</dd>
<dt>
<tt>ch08\collectionDML.sql</tt></dt>
<dd>
Illustrates DML operations on tables with collection columns</dd>
<dt>
<tt>ch08\collectionLoops.sql</tt></dt>
<dd>
Illustrates the FIRST, LAST, NEXT, and PRIOR collection methods</dd>
<dt>
<tt>ch08\count.sql</tt></dt>
<dd>
Illustrates the COUNT collection method</dd>
<dt>
<tt>ch08\delete.sql</tt></dt>
<dd>
Illustrates the DELETE collection method</dd>
<dt>
<tt>ch08\exists.sql</tt></dt>
<dd>
Demonstrates the EXISTS collection method</dd>
<dt>
<tt>ch08\extend.sql</tt></dt>
<dd>
Demonstrates the EXTEND collection method</dd>
<dt>
<tt>ch08\extendDelete.sql</tt></dt>
<dd>
Illustrates the interaction between EXTEND and DELETE</dd>
<dt>
<tt>ch08\indexBy.sql</tt></dt>
<dd>
Illustrates index-by tables</dd>
<dt>
<tt>ch08\Library.sql</tt></dt>
<dd>
Demonstrates operations on stored nested tables</dd>
<dt>
<tt>ch08\LibraryOperator.sql</tt></dt>
<dd>
Demonstrates SQL operators on stored nested tables</dd>
<dt>
<tt>ch08\limit.sql</tt></dt>
<dd>
Illustrates the LIMIT collection method</dd>
<dt>
<tt>ch08\multilevel.sql</tt></dt>
<dd>
Illustrates multilevel collections</dd>
<dt>
<tt>ch08\nested.sql</tt></dt>
<dd>
Illustrates nested tables</dd>
<dt>
<tt>ch08\nonSequential.sql</tt></dt>
<dd>
Illustrates the behavior of INSERTing a nested table into the database</dd>
<dt>
<tt>ch08\nullTable.sql</tt></dt>
<dd>
Illustrates a NULL nested table</dd>
<dt>
<tt>ch08\PrintRequired.sql</tt></dt>
<dd>
Demonstrates a query of a varray column into a PL/SQL variable</dd>
<dt>
<tt>ch08\tabAssign.sql</tt></dt>
<dd>
Illustrates ORA-6533 with nested tables</dd>
<dt>
<tt>ch08\tabObject.sql</tt></dt>
<dd>
Demonstrates an index-by table of objects</dd>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?