Thank you for purchasing Oracle 10g PL/SQL Programming!
The examples provided here are divided by chapter, and match those found in the book. Each chapter contains a script to create the schema with all necessary permissions. The permissions granted for the schemas change between chapters, so be sure to run the schema creation script for each chapter and not rely on the one created in another chapter. To avoid permissions problems it is highly recommended that the schema creation script we provide be used, but you may also create your own schema as long as all required privileges are granted.
The examples for each chapter are created to run independent of objects created in other chapters. In other words - no cross-chapter dependencies. This means you can jump from chapter 10 to 17, and have no problem running chapter 17's examples.
When creating your database, be sure to install Oracle Text as it is used for examples in multiple chapters. If not installed, some examples will not work and you will receive errors on schema creation. Oracle Text is included in both Standard and Enterprise editions, so either release can be used.
All examples were tested on Windows and Linux ports of Oracle 10g Release 1. Should you have ANY problem with the examples, feel free to e-mail FEEDBACK@PLSQLBOOK.COM, and we will respond to the issue promptly.
EXAMPLES
Chapter 1: Introduction to PL/SQL
------------------------------------
CreateUser.sql
This script creates the plsql user for chapter 1
examples. You must run this script as SYS or
SYSTEM as SYSDBA. The script can be rerun.
PlsqlBlock.sql
This script contains an example of a PL/SQL block of code.
Chapter 2: Using SQL*Plus and JDeveloper
------------------------------------------
CreateUser.sql
This script creates the plsql user for chapter 2
examples. You must run this script as SYS or
SYSTEM as SYSDBA. The script can be rerun.
DbmsOutput.sql
This script demonstrates the DBMS_OUTPUT package.
Debug.sql
This script demonstrates debugging PL/SQL with JDeveloper.
Chapter 3: PL/SQL Basics
--------------------------
CreateUser.sql
This script creates the plsql user for chapter 3
examples. You must run this script as SYS or
SYSTEM as SYSDBA. The script can be rerun.
AnonymousBlock.sql
This script demonstrates the structure of an
anonymous block.
BindVariables.sql
This script demonstrates the use of bind variables.
BlockStructure.sql
This script demonstrates the structure of a block.
Boolean.sql
This script demonstrates how to assign a value
to a variable of type boolean.
BooleanLiteral.sql
This script demonstrates Boolean literals.
Case.sql
This script demonstrates CASE.
CompileError.sql
This script demonstrates the compile time warnings
generated by Oracle.
CompileWarning.sql
This script demonstrates the DBMS_WARNING package.
DateTimeLiteral.sql
This script demonstrates Date/Time literals.
Goto.sql
This script demonstrates the GOTO command.
If.sql
This script demonstrates IF-THEN, IF-THEN-ELSE,
and IF-THEN-ELSIF.
Interval.sql
This script demonstrates the use of the INTERVAL types.
Loop.sql
This script demonstrates LOOPs.
MultiLineComment.sql
This script demonstrates the use of multi-line
comment blocks.
NamedBlock.sql
This script demonstrates the structure
of a named block.
NestedBlock.sql
This script demonstrates a nested block.
Number.sql
This script demonstrates the NUMBER datatype.
PLSQL_Warnings.sql
This script demonstrates the PLSQL_WARNINGS parameter.
Ref_Cursor.sql
This script demonstrates the use of REF CURSOR.
Reserved.sql
This script prints a list of reserved words.
SingleLineComment.sql
This script demonstrates the use of single line comments.
StringLiteral.sql
This script demonstrates the different ways in
which 10g handles apostrophes.
Timestamp.sql
This script demonstrates the TIMESTAMP datatypes.
Trigger.sql
This script demonstrates the use of a trigger.
Variables.sql
This script declares a variable as a constant
then attempts to change the assigned value.
Visibility.sql
This script demonstrates variable visibility.
WhiteSpace.sql
This script demonstrates shows poor design
when white space is not used.
WrapAfter.plb
This file shows what a wrapped file looks like.
WrapBefore.sql
This file is used in the example showing how
to wrap PL/SQL.
WrapSeed.sql
This script demonstrates the Wrap utility.
Chapter 4: Using SQL with PL/SQL
----------------------------------
CreateUser.sql
This script creates the plsql user for chapter 4
examples. You must run this script as SYS or
SYSTEM as SYSDBA. The script can be rerun.
Autonomous.sql
This script demonstrates how autonomous transactions work.
BasicSelect.sql
This script demonstrates how to use a basic select
statement in a PL/SQL block.
ContextArea1.sql
This script shows how cursors work with the context
area, and remain consistent after opened.
ContextArea2.sql
This script demonstrates how changes to the database
impact processing of records after a cursor is opened.
Conversion.sql
This script demonstrates the TO_CHAR and TO_DATE
conversion functions.
CursorForLoop.sql
This script demonstrates the use of the Cursor For Loop.
CursorSubquery.sql
This script demonstrates the use of the cursor subquery.
CursorVariable1.sql
This script demonstrates the use of REF CURSOR.
CursorVariable2.sql
This script demonstrates the use of SYS_REFCURSOR.
DateTime.sql
This script demonstrates a few date functions.
DDL.sql
This script demonstrates how DDL doesn't work with PL/SQL.
Delete.sql
This script demonstrates how DELETEs work with PL/SQL.
Error.sql
This script demonstrates error functions SQLERRM
and SQLCODE.
ExplicitAttribute.sql
This script demonstrates the use of cursor attributes.
GreatestLeast.sql
This script demonstrates the Greatest and Least functions.
ImplicitAttribute.sql
This script demonstrates the use of cursor attributes.
Insert.sql
This script demonstrates how INSERTs work with PL/SQL.
Level.sql
This script shows the pseudocolumn LEVEL and an example
of using the levels.
LevelUpdate.sql
This script shows the pseudocolumn LEVEL and an example
of using the levels with an update.
Like.sql
This script demonstrates the use of the LIKE operator.
LockSession1.sql
This script demonstrates how transactions use locks,
commits, and rollbacks. This script is for the first
session as noted in the book.
LockSession2.sql
This script demonstrates how transactions use locks,
commits, and rollbacks. This script is for the second
session as noted in the book.
Lower.sql
This script demonstrates the LOWER function.
NDS.sql
This script demonstrates how NDS works with PL/SQL.
OpenCursor.sql
This script demonstrates what happens when the number
of cursors opened exceeds the open_cursors value. For
this example, set the value of open_cursors to 20 in
the init.ora file.
RegexpLike.sql
This script demonstrates the use of the REGEXP_LIKE
function.
Round.sql
This script demonstrates the ROUND function.
RowID.sql
This script demonstrates the use of the rowid pseudo
column.
Savepoint.sql
This script demonstrates how transactions use savepoints.
SimpleLoop.sql
This script shows how simple loops are written.
TextIndex.sql
This script demonstrates indexing using Oracle Text.
Update.sql
This script demonstrates how UPDATEs work with PL/SQL.
UpdateDual.sql
This script demonstrates how DML works with PL/SQL.
WhereCurrentOf.sql
This script demonstrates how UPDATEs work with PL/SQL
and the WHERE CURRENT OF clause.
WhileLoop.sql
This script demonstrates the use of the WHILE loop.
Chapter 5: Records
--------------------
Chapter 6: Collections
-------------------------
Chapter 7: Error Handling
---------------------------
没有合适的资源?快使用搜索试试~ 我知道了~
Oracle10g-PL-SQL-Programming.rar_plsql
共317个文件
sql:300个
ora:6个
txt:2个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 15 浏览量
2022-09-24
04:05:06
上传
评论
收藏 806KB RAR 举报
温馨提示
Oracle Database 10g PLSQL程序设计 源代码
资源推荐
资源详情
资源评论
收起资源包目录
Oracle10g-PL-SQL-Programming.rar_plsql (317个子文件)
writestr1.c 1KB
writestr2.c 1KB
README.html 58KB
ReadFile1.java 2KB
Logger.java 1KB
0072230665.jpg 27KB
listener3.ora 1KB
listener2.ora 1KB
listener1.ora 1KB
tnsnames2.ora 666B
tnsnames3.ora 666B
tnsnames1.ora 647B
WrapAfter.plb 724B
dbms_sql.sql 42KB
nds_sqle.sql 24KB
nds_sql.sql 24KB
Autonomous.sql 23KB
ContextArea2.sql 23KB
Debug.sql 23KB
Case.sql 23KB
RowID.sql 23KB
If.sql 22KB
BindVariables.sql 22KB
CompileWarning.sql 22KB
ExplicitAttribute.sql 22KB
LockSession1.sql 22KB
ContextArea1.sql 22KB
BasicSelect.sql 22KB
OpenCursor.sql 22KB
tables.sql 22KB
tables.sql 22KB
WhereCurrentOf.sql 22KB
CursorSubquery.sql 22KB
NamedBlock.sql 22KB
PLSQL_Warnings.sql 22KB
NDS.sql 22KB
AnonymousBlock.sql 22KB
tables.sql 22KB
tables.sql 22KB
Savepoint.sql 22KB
NestedBlock.sql 22KB
Update.sql 22KB
WhiteSpace.sql 22KB
PlsqlBlock.sql 22KB
Like.sql 21KB
Delete.sql 21KB
Insert.sql 21KB
RegexpLike.sql 21KB
MultiLineComment.sql 21KB
SingleLineComment.sql 21KB
ImplicitAttribute.sql 21KB
CursorVariable1.sql 21KB
WhileLoop.sql 21KB
SimpleLoop.sql 21KB
Ref_Cursor.sql 21KB
CursorVariable2.sql 21KB
CursorForLoop.sql 21KB
WrapSeed.sql 21KB
ObjMaintain.sql 13KB
UtlRef.sql 9KB
CreateUser.sql 8KB
execute.sql 7KB
IsOf.sql 7KB
InsteadBooksAuthors.sql 7KB
Submit.sql 7KB
CreateJob.sql 7KB
Treat.sql 7KB
create_record7.sql 6KB
CreateUser.sql 6KB
Convert.sql 6KB
CreateUser.sql 6KB
Inheritance.sql 6KB
Inheritance.sql 6KB
CreateUser.sql 6KB
create_record5.sql 6KB
Change.sql 6KB
Run.sql 6KB
Broken.sql 5KB
RestrictReferences.sql 5KB
invokers.sql 5KB
overload.sql 5KB
Remove.sql 5KB
UserDefined.sql 5KB
CreateUser.sql 5KB
CreateUser.sql 5KB
dbms_sql_03.sql 4KB
create_library2.sql 4KB
parameterModes.sql 4KB
create_library1.sql 4KB
ClobCompare.sql 4KB
LoadLOBFromFile.sql 4KB
create_pipe3.sql 4KB
create_user.sql 4KB
LevelUpdate.sql 4KB
create_record6.sql 4KB
CreateUser.sql 4KB
NclobAppend.sql 4KB
BfileCloseAll.sql 4KB
next_item_type.sql 4KB
InventoryOps2.sql 4KB
共 317 条
- 1
- 2
- 3
- 4
资源评论
邓凌佳
- 粉丝: 65
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功