readme.txt

介绍Oracle PL SQL编程

ExceptionInit.sql
	This script demonstrates the EXCEPTION_INIT pragma.
OutOfScope.sql
	This script demonstrates the scope of exceptions.
SQLERRM.sql
	This script demonstrates the use of SQLERRM.
tables.sql
	This script creates the tables and data used by other 
	examples in this chapter. 
UserDefined.sql
	This script demonstrates user defined exceptions.
VerifyAuthors.sql
	This procedure demonstrates the use of RAISE_APPLICATION_ERROR.


Chapter 8: Creating Procedures, Functions, and Packages
----------------------------------------------------------
	For this set of examples, make sure you run tables.sql 
	after creating the schema. All other example scripts 
	depend on the objects created in tables.sql.
CreateUser.sql
	This script creates the plsql user for chapter 8 
	examples. You must run this script as SYS or 
	SYSTEM as SYSDBA. The script can be rerun.
AddNewAuthor.sql
	This script demonstrates how to create and call a 
	simple procedure.
AddNewBook.sql
	This procedure will insert a new book into the books 
	table. It also demonstrates default parameters.
callANA.sql
	This block illustrates how to call the AddNewAuthor function.
CallMe.sql
	This script demonstrates positional vs. named 
	parameter passing.
calls.sql
	This script demonstrates the use of the CALL statement.
callSL.sql
	This block illustrates how to call a packaged procedure 
	which takes a named type parameter.
CopyFast.sql
	This package illustrates the possible speed benefits of NOCOPY.
InventoryOps.sql
	This script demonstrates a package.
InventoryOps2.sql
	This version of the InventoryOps package contains an 
	extra procedure in the package body.
NoCopyTest.sql
	This script illustrates the behavior of NOCOPY.
noparams.sql
	This procedure and function demonstrate the syntax of 
	calling subprograms with no parameters.
objectOverload.sql
	This script demonstrates overloading based on user 
	defined object types.
overload.sql
	This version of InventoryOps demonstrates an overloaded 
	procedure, StatusList.
packageError.sql
	This package will not compile because the specification 
	and body do not match.
ParameterLength.sql
	This script illustrates constraints on formal parameters.
parameterModes.sql
	These procedures are used to demonstrate the behavior 
	of IN, OUT, and IN OUT parameter modes.
RaiseError.sql
	This script shows the behavior of exceptions raised 
	within subprograms.
Random.sql
	This illustrates package initialization.
tables.sql
	This script creates the tables and data used by other 
	examples in this chapter. 
ThreeAuthors.sql
	This script demonstrates a function and how to call it.


Chapter 9:
------------
 
 
 
Chapter 10:
-------------
 
 
 
Chapter 11:
-------------
 
 
 
Chapter 12:
-------------
 
 
 
Chapter 13:
-------------
 
 
 
Chapter 14: Introduction to Objects
-------------------------------------
CreateUser.sql
	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.
AttributeChain.sql
	This script demonstrates attribute chaining.
ComplexObj.sql
	This script demonstrates complex objects.
ConstructorMethod.sql
	This script demonstrates the user-defined constructor method.
DynamicDispatch.sql
	This script demonstrates dynamic dispatch/dynamic polymorphism.
Inheritance.sql
	This script demonstrates object type inheritance.
MapMethod.sql
	This script demonstrates the map method.
MemberMethod.sql
	This script demonstrates the member method.
ObjInit.sql
	This script demonstrates object initialization.
OrderMethod.sql
	This script demonstrates the order method.
StaticMethod.sql
	This script demonstrates the static method.
TypeAttribute.sql
	This script demonstrates the use of %TYPE.
TypeEvolution.sql
	This script demonstrates type evolution for object maintenance.


Chapter 15: Objects in the Database
--------------------------------------
CreateUser.sql
	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.
AttributeChain.sql
	This script demonstrates attribute chaining.
ColObj.sql
	This script demonstrates column objects.
ForwardDeclaration.sql
	This script demonstrates forward type declarations.
Inheritance.sql
	This script demonstrates object type inheritance.
IsDangling.sql
	This script demonstrates how to handle dangling REFs.
IsOf.sql
	This script demonstrates the IS OF type statement.
ObjectTable.sql
	This script demonstrates the creation of an 
	object table, and includes an anonymous block 
	to demonstrate DML operations against an object table.
ObjectView.sql
	This script demonstrates object view creation.
ObjMaintain.sql
	This script demonstrates type evolution.
RefObj.sql
	This script demonstrates object references using REF.
Treat.sql
	This script demonstrates the TREAT function.
UtlRef.sql
	This script demonstrates the UTL_REF package.


Chapter 16: Large Objects
---------------------------
CreateUser.sql
	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.
BfileClose.sql
	This script tests the DBMS_LOB.CLOSE procedure.
BfileCloseAll.sql
	This script tests the DBMS_LOB.FILECLOSEALL procedure.
BfileFileExists.sql
	This script tests the DBMS_LOB.FILEEXISTS procedure.
BfileIsOpen.sql
	This script tests the DBMS_LOB.ISOPEN function.
ClobCompare.sql
	This script tests the DBMS_LOB.COMPARE function.
Convert.sql
	This script tests the DBMS_LOB.CONVERTTOBLOB 
	and DBMS_LOB.CONVERTTOCLOB procedures.
CreateLobTables.sql
	This script demonstrates storage options available for LOBs.
LoadFromFile.sql
	This script tests the DBMS_LOB.LOADFROMFILE procedure.
LoadLOBFromFile.sql
	This script tests the DBMS_LOB.LOADLOBFROMFILE procedure.
LobInsert.sql
	This script demonstrates LOB inserts.
LobUpdate.sql
	This script demonstrates LOB updates.
LongToLob.sql
	This script demonstrates the conversion of Longs to LOBs.
NCLOBAppend.sql
	This script demonstrates the DBMS_LOB.APPEND procedure.
Returning.sql
	This script demonstrates returning clause.
TextIndex.sql
	This script demonstrates indexing using Oracle Text.
VarrayLob.sql
	This script demonstrates user-defined LOBs.


Chapter 17: Scheduling Tasks
------------------------------
CreateUser.sql
	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.
Broken.sql
	This script tests the DBMS_JOB.BROKEN procedure.
Change.sql
	This script tests the DBMS_JOB.CHANGE procedure.
CreateJob.sql
	This script tests the DBMS_SCHEDULER.CREATE_JOB procedure.
Remove.sql
	This script tests the DBMS_JOB.REMOVE procedure.
Run.sql
	This script tests the DBMS_JOB.RUN procedure.
Submit.sql
	This script tests the DBMS_JOB.SUBMIT procedure.