《Oracle V5.0-6.0参考大全》求取 ⇩

第0章 概述1

0.1 本书的结构1

0.2 关于本书2

第一部分 基本的数据库概念第一章 共享知识和成功4

1.1 合作之道5

1.2 人人都有“数据”6

1.3 ORACLE的家族语言7

1.3.1 信息表8

1.3.2 结构查询语言（Structured Query Language）8

1.3.3 一个简单的ORACLE查询的例子9

1.3.4 为什么叫”关系型”10

1.4 一些日常例子11

1.5 一个一百年之久的例子13

第二章 关系数据库中的危险17

2.1 真的如此容易吗？17

2.2 有什么危险？17

2.3 新的眼光的重要性18

2.4 代码、缩写和命名标准19

2.5 对用户的好处21

2.6 怎样减少混乱21

2.6.1 数据规范化22

2.6.2 逻辑模型22

2.6.3 第一范式24

2.6.4 第二范式25

2.6.5 第三范式25

2.6.6 在数据中航行26

2.6.7 表和列的英文名字28

2.6.8 数据的英文名30

2.7 数据和名字的大小写31

2.8 规范化名字31

2.9 抓住机会32

第二部分 SQL——从初学者到专家第三章 SQL语言基础33

3.1 格式34

3.2 用SQL从表中选择数据35

3.3 select,from,where和order by38

3.4 逻辑和值40

3.4.1 单值测试40

3.4.2 值表的简单测试46

3.4.3 组合逻辑48

3.5 where的另一种应用——子查询50

3.5.1 单值子查询51

3.5.2 列表值子查询51

3.6 表的连接53

3.7 创建视图55

3.7.1 扩展视图的视图57

第四章 基本的SQLPLUS报表生成和命令58

4.1 建立一个简单的报表59

4.1.1 remark60

4.1.2 set headsep60

4.1.3 ttitle和btitle60

4.1.4 column（列）64

4.1.5 break on65

4.1.6 Compute sum（计算总和）66

4.1.7 set linesize（设置行宽）66

4.1.8 set pagesize（设置页长）66

4.1.9 set newpage（设置页与页之间的空行数）67

4.1.10 spool［缠卷，即存入］67

4.1.11 ／＊＊68

4.1.12 关于列标题的一些说明68

4.2 其他功能69

4.2.1 命令行编辑程序69

4.2.2 set pause（设置暂停）72

4.2.3 save72

4.2.4 Editing72

4.2.5 host73

4.2.6 加入SQLPLUS命令73

4.2.7 start（启动）74

4.3 检查SQLPLUS环境74

4.4 积木块（building blocks）76

第五章 文本信息的获取和修改77

5.1 数据类型77

5.2 串是什么？78

5.3 符号用法78

5.4 串函数的基本用法80

5.5 串的分割和连接81

5.5.1 RPAD和LPAD81

5.5.2 LTRIM和RTRIM82

5.5.3 组合两个函数：83

5.5.4 组合更多的函数：86

5.5.5 LOWER,UPPER和INITCAP86

5.5.6 LENGTH88

55.7 SUBSTR88

5.5.8 INSTR91

5.6 串函数用于order by和where子句95

5.6.1 SOUNDEX96

5.7 小结98

第六章 使用数字99

6.1 三类数字函数99

6.2 表示符号101

6.3 单值函数101

6.3.1 加，减，乘，除（＋，-，＊，／）102

6.3.2 NULL（空）102

6.3.3 空值替换103

6.3.4 ABS——绝对值函数103

6.3.5 CEIL104

6.3.6 FLOOR104

6.3.7 MOD104

6.3.8 POWER104

6.3.9 SQR——平方根105

6.3.10 ROUND和TRUNC105

6.3.11 SIGN106

6.3.12 VSIZE106

6.4 聚组函数107

6.4.1 聚组函数中的Nulls107

6.4.2 Example（例子）108

6.4.3 AVG,COUNT,MAX,MIN和SUM109

6.4.4 组合聚组函数和单值函数109

6.4.5 STDDEV和VARIANCE111

6.4.6 聚组函数中的DISTINCT111

6.5 列表函数112

6.6 用MAX和MIN查找行113

6.7 优先级和括号114

6.8 小结116

第七章 日期（dates）、过去（then）、现在（now）和差值117

7.1 日期运算（Date Arithmetic）117

7.1.1 系统日期（SysDate）117

7.1.2 两个日期间差别（Difference Between Two Datas）118

7.1.3 加月份（Adding Months）120

7.1.4 减月份（Subtracting Months）120

7.1.5 GREATEST和LEAST120

7.1.6 NEXT_DAY122

7.1.7 LAST_DAY123

7.1.8 MONTH_BETWEEN Two Dates123

7.1.9 组合日期函数（Combining Date Functions）124

7.2 日期运算中的四舍五入（round）与截尾（TRUNC）124

7.3 TO_DATE和TO_CHAR的格式125

7.3.1 NEW_TIME时区转换函数130

7.3.2 TO_DATE运算131

7.4 where子句中的Dates133

第八章 转换函数135

8.1 基本转换函数137

8.1.1 数据类型的自动转换139

8.1.2 数据类型自动转换中的注意点141

8.2 特殊转换函数141

8.3 变换函数142

8.3.1 翻译函数（TRANSLATE）142

8.3.2 译码函数（DECODE）143

8.4 转换与变换144

第九章 聚组函数145

9.1 group by和having的使用147

9.1.1 加入order by子句149

9.1.2 执行的次序150

9.2 聚组函数的视图150

9.2.1 用别名对列项进行更名151

9.3 聚组函数视图的功能153

9.3.1 having子句中的逻辑154

9.3.2 用列项和聚组函数排序（order by）155

9.3.3 连接列项156

9.4 where,having,group by和order by156

第十章 当查询互相依赖时157

10.1 高级子查询（Advanced Subqueries）157

10.1.1 相关联的子查询（Correlated Subqueries）159

10.1.2 并列逻辑测试162

10.1.3 EXISTS和其相关的子查询164

10.2 外连接165

10.2.1 用外连接替换NOT IN166

10.3 UNION,INTERSECT和MINUS167

10.3.1 在子查询中使用UNION.INTERSECT和MINUS171

10.3.2 关于UNION,INTERSECT的限制和MINUS175

第十一章 一些复杂的可能性177

11.1 创立一种复杂的视图177

11.1.1 组视图178

11.1.2 汇总视图179

11.1.3 复合视图179

11.2 Connect by子句181

11.2.1 排除叶子和分？184

11.2.2 向根的回溯访问186

11.2.3 基本规则188

第十二章 用SQLPLUS生成报表190

12.1 高级格式190

12.1.1 关于数据的格式问题190

12.1.2 Break on191

12.1.3 Break on子句中的列序193

12.1.4 break on Rew194

12.1.5 补充视图195

12.1.6 与ttitle和btitle一起使用的列195

12.1.7 关于break和Compute命令的更多信息199

12.2 Set termout off和Set termout on203

12.3 SQLPLUS中的变量203

12.3.1 另外一些使用变量的地方206

12.4 数字格式206

12.5 使用mask.sgl207

12.6 使用缓冲保存SQLPLUS命令208

12.6.1 使用spool命令保存当前定义210

12.7 Show all和Spooling210

12.8 行的卷绕211

12.8.1 fold_after和fold_before211

12.9 附加报告控制212

第十三章 改变数据：插入、修改、删除213

13.1 Insert命令213

13.1.1 插入时间214

13.1.2 用sclect语句插入214

13.2 rollback,commit和antocommit命令215

13.2.1 隐含的Commit操作215

13.2.2 自动rollback215

13.3 Delete（删除）命令：216

13.4 update命令218

13.4.1 嵌入select语句的update命令219

13.4.2 用NULL进行修改220

第十四章 函数和变量的高级用法221

14.1 Order by命令中的函数221

14.2 直方图表221

14.3 使用TRANSLATE命令224

14.3.1 删去字符225

14.3.2 清除＄符号和逗号226

14.4 在数据中插入逗号226

14.5 复杂的剪裁和拼接228

14.6 变量和伪替换231

14.6.1 关于变量的另外一些信息234

14.6.2 相关的set命令236

第十五章 DECODE——令人惊奇的功能237

15.1 If,Then,Else237

15.2 例子：过期发票237

15.2.1 把客户收集起来239

15.2.2 用空值来进行orde by243

15.3 表的翻转244

15.4 在DECODE中运用MOD246

15.5 order by和行号248

15.6 在then和else中的列和计算249

15.7 在DECODE中的大于、小于和等于250

第十六章 建立、删除、改变表和视图253

16.1 建立一张表253

16.1.1 字符宽度和数字精度254

16.1.2 Autocommit和插入错误255

16.1.3 插入过程中的舍入255

16.1.4 在建表中的NULL和NOT NULL256

16.2 删除表256

16.3 改变表257

16.3.1 加入和修改列的规则258

16.4 创立一个视图259

16.4.1 视图的稳定性259

16.4.2 在视图中的orader by260

16.5 从一个表建立另一个表261

16.5.1 数据的新旧度262

16.6 TAB和USER_TABLES,USER_VIEWS和USER_CLUSTERS262

第十七章 权限263

17.1 有关数据库管理人员的权限问题263

17.1.1 Connect263

17.1.2 resource263

17.1.3 dba263

17.1.4 grant命令的格式264

17.1.5 改变口令字264

17.1.6 取消特权264

17.2 有关用户的权限问题265

17.2.1 用connect命令转移到别的用户265

17.2.2 建立同义词267

17.2.3 使用未授权允许的特权267

17.2.4 传递特权268

17.2.5 一个用户赋权给另一用户的格式269

17.2.6 赋权对指定列的修改270

17.2.7 取消权力270

17.2.8 用户安全性270

17.2.9 赋予所有用户的访问权271

17.3 赋予限制的Resource权限271

第十八章 改变ORACLE的环境272

18.1 索引272

18.1.1 创立索引273

18.1.2 加强唯一性275

18.1.3 何时建立索引275

18.1.4 何时忽略索引275

18.1.5 索引列的多样性276

18.1.6 在表中使用多少索引276

18.1.7 检查索引276

18.1.8 在order by中的限制使用277

18.1.9 在数据库中放置索引278

18.2 表空间和数据库的结构278

18.2.1 建立分区（第5版）280

18.2.2 建立表空间（第6版）281

18.3 簇282

18.3.1 建立和改变簇参数284

18.3.2 表是如何存储的284

18.4 序列285

18.5 ORACLE技术用语285

第三部分 项目设计第十九章 良好的设计需要人的参与288

19.1 了解应用任务289

19.1.1 任务的概貌290

19.2 了解数据291

19.2.1 原子数据模型292

19.2.2 原子业务模型292

19.3 业务模型292

19.4 数据项292

19.5 查询和报告293

19.6 设计294

第二十章 性能和设计295

20.1 非规范化和数据完整性296

20.1.1 有意义的关键字296

20.1.2 真正非规范化298

20.1.3 行、列和容量299

20.1.4 内存约束300

20.1.6 你应该这样做吗？301

20.2 计算表301

20.3 设计301

第二十一章 人工设计十诫302

21.1 面向目标名标准化302

21.1.1 层次名完整性302

21.1.2 外部键304

21.1.3 单一性305

21.1.4 简洁性306

21.1.5 目标名辞典307

21.2 智能键和列307

21.3 戒律308

第四部分 用ORACLE产品开发第二十二章 SQL＊PLUS309

22.1 生成查询代码309

22.2 加载变量315

22.2.1 改变变量值316

22.2.2 用ttitle使用变量317

22.2.3 字符串及数据317

22.3 产生和嵌套开始文件和命令318

22.3.1 应用主进程320

22.4 其他用途320

第二十三章 SQL＊FORMS321

23.1 缺省where子句321

23.1.1 动态修改缺省where子句321

23.1.2 导致不工作的原因324

23.1.3 如何调试动态where子句325

23.2 高页调试327

23.3 结论327

23.4 日期330

23.5 金钱331

第五部分 字母顺序参考指南第二十四章 字母顺序参考指南334

24.1 字母顺序参考指南包含的内容334

24.2 以字母为序的参考手册不包含的内容334

24.3 条目的一般格式335

24.4 RPAD335

24.4.1 每一条目的组成335

24.4.2 变量的标准用法336

24.4.3 其他的标准说明336

24.4.4 一个列表的其他元素337

24.5 列表的顺序337

24.5.1 符号337

24.6 _（下划线）338

24.7 _EDITOR338

24.8 ”（双引号）338

24.9 ＃（英镑符号）339

24.10 ＃COPY339

24.11 ＃ERASE339

24.12 ＃EXEMACRO339

24.13 ＃HOST343

24.14 ＄（美元符号）343

24.15 ＄＄DATE＄＄：344

24.16 ＄＄DATETIME＄＄344

24.17 ＄＄TIME＄＄344

24.18 ％（百分号）：344

24.19 ％FOUND345

24.20 ％ISOPEN346

24.21 ％NOTFOUND346

24.22 ％ROWCOUNT346

24.23 ％ROWTYPE347

24.24 ％TYPE348

24.25 ＆或＆＆（与号或者双与号）349

24.26 ’（单引号）349

24.27 （）（圆括号）350

24.28 ＊（乘号）350

24.29 ＊＊（取幂符号）350

24.30 ＋（加号）350

24.31 －（减号［形式1］）350

24.32 －（连字符［形式2］）351

24.33 ．（句号［形式1］351

24.34 ．（句号［形式2］）351

24.35 ．．（到、至）352

24.36 ／（除号［形式11）：352

24.37 ／（斜线［形式2］）352

24.38 ／＊＊／（注释）352

24.39 ：（冒号，主变量前缀）353

24.40 ：＝（赋值号）353

24.41 ；（分号）353

24.42 〈〈〉〉（PL/SQL标号名分隔符）：354

24.43 ＠（特征标号［形式1］）：354

24.44 ＠（特征标号［形式2］）：354

24.45 ｜（条形符号）：354

24.46 ｜｜（连接符）355

24.47 ABORT_QUERY355

24.48 ABS（绝对值）355

24.49 ACCEPT356

24.50 ACCESS（数据库对像）356

24.51 ACTIONS(SQL＊FORMS)356

24.52 ADD356

24.53 ADD_MONTHS：356

24.54 ADDRESS（行）357

24.55 AFTER IMAGE JOURNALING357

24.56 ALERT(SQL＊FORMS V3)357

24.57 ALIAS357

24.58 ALL357

24.59 ALTER CLUSTER（形式1——ORACLE V5）360

24.60 ALTER CLUSTER（形式2——ORACLE V6）360

24.61 ALTER DATABASE361

24.62 ALTER INDEX（形式1——ORACLE V5）362

24.63 ALTER INDEX（形式2——ORACLE V6）362

24.64 ALTER PARTITION362

24.65 ALTER ROLLBACK SEGMENT363

24.66 ALTER SEQUENCE363

24.67 ALTER SESSION364

24.68 ALTER SPACE364

24.69 ALTER TABLE（形式1—ORACLE V5）364

24.70 ALTER TABLE（形式2—ORACLE V6）365

24.71 ALTER TABLESPACE366

24.72 ALTER USER366

24.73 ANCHOR_VIEW367

24.74 AND367

24.75 ANONYMOUS BLOCK(SQL*FORMS)367

24.76 ANSI367

24.77 ANY367

24.78 APPEND370

24.79 APPLICATION371

24.80 APPLICATION_CHARACTERISTIC371

24.81 ARCH PROCESS371

24.82 ARCHIVE371

24.83 ARGUMENT371

24.84 ARH371

24.85 ARRAY PROCESSING372

24.86 ARRAY SIZE(SQL＊FORMS)372

24.87 ARRAY SIZE(SQL＊PLUS)372

24.88 ASCII372

24.89 ASYNCHRONOUS READAHEAD373

24.90 ASYNCHRONOUS TERMINAL373

24.91 ATTRIBUTE373

24.92 AUDIT373

24.93 AUDIT TRAIL374

24.94 AUDITING375

24.95 AUTHORIZATION375

24.96 AUTOCOMMIT375

24.97 AUTOSKIP(SQL＊FORMS)375

24.98 AVG375

24.99 B＊TREE375

24.100 BACKGROUND PROCESS375

24.101 BAR376

24.102 BASE TABLE(SQL＊FORMS)376

24.103 BASE TABLE FIELD(SQL＊FORMS)376

24.104 BEFORE IMAGE FILE376

24.105 BEGIN376

24.106 BELL376

24.107 BETWEEN377

24.108 BIND PHASE377

24.109 BIND VARIABLE377

24.110 BIW377

24.111 BLOCK377

24.112 BLOCK_CHARACTERISTIC377

24.113 BLOCK_LEVEL TRIGGER(SQL＊FORMS)378

24.114 BLOCK_MENU378

24.115 BLOCK MODE TERMINAL378

24.116 BLOCK STRUCTURE378

24.117 BOOTSTRAP SEGMENT380

24.118 BOX(SQL＊FORMS)380

24.119 BRANCH380

24.120 BREAK（形式1—SQL＊FORMS）380

24.121 BREAK（形式2—SQL＊PLUS）380

24.122 BTITLE（bottom title底标题）381

24.123 BUFFER382

24.124 BUFFERS（DATABASE数据库）382

24.125 BUFFERS(REDO LOG)382

24.126 BWR382

24.127 BY382

24.128 C LANGUAGE382

24.129 CACHE MANAGER383

24.130 CACHES383

24.131 CALL383

24.132 CALL_INPUT383

24.133 CALL_QUERY383

24.134 CASE384

24.135 CCF384

24.136 CEIL385

24.137 CHAINED BLOCK385

24.138 CHAINED ROW385

24.139 CHANGE385

24.140 CHAR DATATYPE386

24.141 CHARACTER FUNCTIONS386

24.141.1 Function Name and Use386

24.142 CHARACTERISTIC(SQL＊FORMS)387

24.143 CHARTOROWID388

24.144 CHECKPOINT388

24.145 CHILD388

24.146 CHR388

24.147 CLAUSE389

24.148 CLEANUP PASS389

24.149 CLEAR389

24.150 CLEAR_BLOCK389

24.151 CLEAR_EOL390

24.152 CLEAR_FIELD390

24.153 CLEAR_FORM390

24.154 CLEAR_RECORD390

24.155 CLIENT390

24.156 CLOSE391

24.157 CLN391

24.158 CLOSED DATABASE391

24.159 CLR391

24.160 CLRPIE391

24.161 CLRWHEEL391

24.162 CLUSTER391

24.163 CLUSTER COLUMNS392

24.164 CLUSTER INDEX392

24.165 CLUSTER KEY392

24.166 CMDSEP392

24.167 COL392

24.168 COLD START392

24.169 COLLATION392

24.170 COLOR393

24.171 COLUMN（形式1——定义）393

24.172 COLUMN（形式2——SQL＊PLUS）393

24.173 COLUMN CONSTRAINT395

24.174 COLUMN GRAPH395

24.175 COMMAND396

24.176 COMMAND LINE396

24.177 COMMENT396

24.178 COMMIT397

24.179 COMMIT（形式1——嵌入式SQL）397

24.180 COMMIT（形式2——PL/SQL语句）397

24.181 COMMIT（形式3——SQL或SQL＊PLUS）397

24.182 COMMIT_FORM398

24.183 通信协议398

24.184 COMPOSITE INDEX398

24.185 COMPROSSED INDEX398

24.186 COM PUTE398

24.187 CONCAT399

24.188 CONCATENATED INDEX(or KEY)399

24.189 CONCATENATION399

24.190 CONCURRENCY400

24.191 CONDITION400

24.192 CONNECT400

24.193 CONNECT（形式1）400

24.194 CONNECT（形式2——嵌入型SQL）400

24.195 CONNECT BY401

24.196 CONSISTENCY401

24.197 CONSISTENCY CHECK(SQL＊FORMS)402

24.198 CONSTANT TEXT(SQL＊FORMS)402

24.199 CONSTRAINT402

24.200 CONTEXT(SQL＊FORMS)402

24.201 CONTEXT AREA402

24.202 CONTROL BLOCK(SQL＊FORMS)402

24.203 CONTROL FILE402

24.204 CONTROL KEY(SQL＊FORMS)402

24.205 CONVERSION FUNCTIONS402

24.205.1 函数名及使用：403

24.206 CONVERT（形式1——SQL函数）403

24.207 CONVERT（形式2——SQL＊FORMS交互应用的转换器）。404

24.208 COPY（形式1——SQL＊PLUS命令）404

24.209 COPY（形式2——SQL＊FORMS）405

24.210 COPYCOMMIT405

24.211 CORRELATED QUERY406

24.212 COUNT（形式1——SQL函数）406

24.213 COUNT（形式2——SQL＊FORMS）406

24.214 COUNT_QUERY406

24.215 CREATE CLUSTER（形式1——ORACLE V5）406

24.216 CREATE CLUSTER（形式2——ORACLE V6）407

24.217 CREATE CONTIGUOUS FILE(CCF)408

24.218 CREATE DATABASE408

24.219 CREATE DATABASE LINK409

24.220 CREATE INDEX（形式1——ORACLE V5）410

24.221 CREATE INDEX（形式2——ORACLE V6）411

24.222 CREATE PARTITION411

24.223 CREATE_RECORD412

24.224 CREATE ROLLBACK SEGMENT412

24.225 CREATE SEQUENCE412

24.226 CREATE SPACE413

24.227 CREATE SYNONYM414

24.228 CREATE TABLE（Form1——ORACLE V5）414

24.229 CREATE TABLE（形式2——ORACLE V6）415

24.230 Column Constraints416

24.230.1 Table Constraints417

24.230.2 Other parameters（其他参数）417

24.231 CREATE TABLESPACE417

24.232 CREATE VIEW418

24.233 CREATING A DATABASE419

24.234 CRT419

24.235 CRT FILE419

24.236 CURRENT BLOCK(SQL*FORMS)419

24.237 CURRENT BUFFER419

24.238 CURRENT FIELD(SQL*FORMS)420

24.239 CURRENT LINE420

24.240 CURSOR420

24.241 CURSOR COORDINATES420

24.242 CURSOR DESCRIPTOR420

24.243 CURSOR ID420

24.244 DATA CONTROL LANGUAGE（DCL）语句420

24.245 DATA DEFINITION LANGUAGE（DDL）语句420

24.246 DATA DEFINITION LOCKS421

24.247 DATA DICTIONARY421

24.248 DATA DICTIONARY(ORACLE V6)421

24.248.1 Background Processes421

24.248.2 Cluster Keys421

24.248.3 COMMIT和ROLLBACK421

24.248.4 Control files421

24.248.5 Database file structure421

24.248.6 Indexes422

24.248.7 INIT.ORA422

24.248.8 IOR INIT,SHUT，和WARM422

24.248.9 New Lock Modes422

24.248.10 New SQL Commands422

24.248.11 NULL422

24.248.12 Password Encryption423

24.248.13 Referential Integrity423

24.248.14 Reserved Words423

24.248.15 Rollback Segments423

24.248.16 ROWIDS423

24.248.17 SAVEPOINT423

24.248.18 Sequence Numbers423

24.248.19 SET TRANSACTION READ ONLY423

24.248.20 Sorting Sequence for NULL423

24.248.21 STORAGE423

24.248.22 Tables424

24.248.23 Tablespaces424

24.248.24 Temporary Segments424

24.249 DATA DICTIONARY VIEWS(ORACLE V5)424

24.250 DATA DICTIONARY VIEVS(ORACLE V6)425

24.251 DATA INDEPENDENCE428

24.252 DATA LOCKS429

24.253 DATA MANIPULATION LANGUAGE(DML)STATEMENTS429

24.254 DATA SEGMENT429

24.255 DATA TYPES429

24.256 DATABASE430

24.257 DATABASE ADMINISTRATOR(DBA)430

24.258 DATABASE FILE430

24.259 DATABASE LINK430

24.260 DATABASE NAME431

24.261 DATABASE OBJECT431

24.262 DATABASE SPECIFICATION431

24.263 DATABASE SYSTEM431

24.264 DATATYPE431

24.265 DATE431

24.266 DATE FIELD(SQL＊FORMS)431

24.267 DATE FORMATS431

24.268 DATE FUNCTIONS433

24.269 DATUM434

24.270 DBA PRIVILEGE434

24.271 DBA434

24.272 DBWR PROCESS435

24.273 DDL LOCK435

24.274 DEADLOCK435

24.275 DECLARATIVE SQL STATEMENT435

24.276 DECLARE CURSOR（格式1——嵌入SQL）435

24.277 DECLARE CURSOR（指针说明）436

24.278 DECLARE DATABASE（嵌入式SQL）438

24.279 DECLARE EXCEPTION438

24.279.1 其他问题439

24.280 DECLARE STATEMENT（嵌入SQL）440

24.281 DECLARE TABLE440

24.282 DECLARE VARIABLE440

24.283 DECODE441

24.284 DEFAULT442

24.285 DEFAULT CRT442

24.286 DEFAULT DEVICE TYPE(SQL＊FORMS)442

24.287 DEFAULT FORM442

24.288 DEFAULT VALUE442

24.289 DEFAULT_VALUE442

24.290 DEFERRED ROLLBACK SEGMENT442

24.291 DEFINE（格式1-SQL＊FORMS）443

24.292 DEFINE（格式2-SQL＊PLUS）443

24.293 DEFINE（格式3-SQL＊PLUS）443

24.294 DEFINE PHASE443

24.295 DEL444

24.296 DELETE（格式1-PL/SQL）444

24.297 DELETE（格式2-SQL命令）445

24.298 DELETE（格式3-SQL＊FORMS）445

24.299 DELETE_RECORD445

24.300 DELETE TRIGGER(SQL＊FORMS)445

24.301 DEPENDENT PARAMETERS445

24.302 DESCRIBE446

24.302 DESCRIBE PHASE446

24.304 DESELECT446

24.305 DESIGNER(SQL＊FORMS)446

24.306 DETACHED PROCESS446

24.307 DETAIL BLOCK(SQL＊FORMS)446

24.308 DEVICE446

24.309 DEVICE447

24.310 DEVICE INDEPENDENCE(SQL＊FORMS)447

24.311 DICTIONARY CACHE447

24.312 DICTIONARY CACHE LOCKS447

24.312 DICTIONARY LOCKS447

24.314 DICTIONARY OPERATION LOCKS447

24.315 DISCONNECT447

24.316 DISMOUNTED DATABASE447

24.317 DISPLAY DEVICE(SQL＊FORMS)448

24.318 DISPLAY_ERROR448

24.319 DISPLAY FIELD448

24.320 DISPLY_PAGE448

24.321 DISPLAY WIDTH(SQL＊FORMS)448

24.322 DISTINCT448

24.323 DISTRIBUTED DATABASE449

24.324 DISTRIBUTED PROCESSING449

24.325 DISTRIBUTED QUERY449

24.325.1 DMD449

24.325 DML LOCK449

24.326 DMM449

24.327 DMU450

24.328 DOCMENU451

24.329 DOCUMENT451

24.330 DOWN452

24.331 DROP CLUSTER452

24.332 DROP DATABASE LINK（删除数据库连接）452

24.333 DROP INDEX453

24.334 DROP ROLLBACK SEGMENT453

24.335 DROP SEQUENCE453

24.336 DROP SPACE454

24.337 DROP SYNONYM454

24.338 DROP TABLE454

24.339 Drop Tablespace454

24.340 Drop View455

24.341 DSPPCT455

24.342 DSPVAL455

24.343 DUAL455

24.344 DUMP455

24.345 DUMPREP456

24.346 DUPLICATE_FIELD456

24.347 DUPLICATE_RECORD457

24.348 EBCDIC457

24.349 ECHO(SQL＊PLUS)457

24.350 EDIT457

24.351 EDIT FIELD457

24.352 EMBEDDED(SQL＊PLUS)457

24.353 END458

24.354 ENQUEUE458

24.355 ENTER458

24.356 ENTER_QUERY458

24.357 ENTTTY（实体）459

24.358 ENTITY_RELATIONSHIP MODEL459

24.359 EQUI_JOIN459

24.360 ESCAPE(SQL Plus)459

24.361 ERASE459

24.362 ERROR_CODE460

24.363 ERROR_TEXT460

24.364 ERROR_TYPE461

24.365 EXCEPTION461

24.365.1 其他问题463

24.366 EXCEPTION_INIT463

24.367 EXCLUSIVE LOCK464

24.368 EXCLUSIVE MODE464

24.369 EXCLUSIVE MODE LOCKING464

24.370 EXECUTABLE SQL STATEMENT464

24.371 EXECUTE(Dynamic Embedded SQL)465

24.372 EXECUTE IMMEDITATE(Dynamic Embedded SQL)465

24.373 EXECUTE_PHASE466

24.374 EXECUTE_QUERY466

24.375 EXEUTE_TRIGGER466

24.376 EXISTS466

24.377 EXIT(FORM1-PL/SQL)467

24.378 EXIT(Form-2 SQL＊PLUS)467

24.379 EXIT_FORM468

24.380 EXP468

24.380.1 Interactive Mode469

24.380.2 USING EXPORT IN interactive Mode469

24.380.3 Three tlernative Displays470

24.380.4 Command Line Mode(V6 only)471

24.381 EXPLAIN PLAN472

24.382 EXPORT472

24.383 EXPRESSION472

24.384 EXTENT473

24.385 ENTENT BLOCK473

24.386 FAILURE(SQL＊FORMS)473

24.387 FAILURE LABLE(SQL＊FORMS)473

24.388 FEEDBACK(SQL＊PLUS)473

24.389 FETCH473

24.390 FETCH(FORM1-Embedded SQL)473

24.391 FETCH(Form-2-PL/SQL)474

24.392 FIELD475

24.393 FIELD CHARACTERISTIC475

24.394 FIELD LENGTH(SQL＊FORMS)476

24.395 FIELD-LEVEL TRIGGER(SQL＊FORMS)477

24.396 FILE477

24.397 FILE MANAGEMENT LOCKS477

24.398 FILE TYPES477

24.399 FILL-IN ITEM(SQL＊FORMS)477

24.400 FIRST_RECORD477

24.401 FIXED LENGTH(SQL＊FORMS)478

24.402 FIXED VALUE(SQL＊FORMS)478

24.403 FLOOR478

24.404 FLUSH(SQL＊FORMS)478

24.405 FOR(FORM1-Embedded SQL)478

24.406 FOR(FORM.2-PL/SQL)479

24.407 FOREIGN KEY479

24.408 FORM(SQL*FORMS)479

24.409 FORM AREA(SQL＊FORMS)479

24.410 FORM_CHARACTERISTIC479

24.411 FORM FAILURE479

24.412 FORM_FATAL480

24.413 FORM_LEVEL PROCEDURE(SQL＊FORMS Version 3)480

24.414 FORM MENU(SQL＊FORMS)481

24.415 FORM NAMES(SQL＊FORMS)481

24.416 FORM SUCCESS481

24.417 FORMAT481

24.418 FORMAT MASK(SQL＊FORMS VERSION 3)481

24.419 FORMAT MODEL482

24.420 FORMFEED482

24.421 FRAGMENTED DATABASE482

24.422 FREE EXTENTS482

24.423 FREE SPACE482

24.424 FRM(SQL＊FORMS)482

24.425 FROM482

24.426 FSTEXP483

24.427 FULL TABLE SCAN483

24.428 FUNCTION483

24.429 FUNCTION CODE(SQL＊FORMS)483

24.430 FUNCTION KEY(SQL＊FORMS)483

24.431 GENERATE(SQL＊FORMS Interactive Application Generator)483

24.432 GENMENU484

24.433 GENREP484

24.434 GET485

24.435 GLOBAL VARIABLE485

24.436 GO_BLOCK486

24.437 GO_FIELD486

24.438 GO_RECORD486

24.439 GOTO486

24.440 GRANT(Form1-ORACLE V5 and V6)487

24.441 GRANT(Form 2-ORACLE V6 only)488

24.442 GRANT(Form 3-ORACLE V5 and V6)488

24.443 GRAPH489

24.444 GREATEST489

24.445 GROUP BY490

24.446 GROUP FUNCTIONS491

24.446.1 FUNCTION NAME and USE491

24.447 GTITLE491

24.448 HAVING491

24.449 HEADING(SQL＊PLUS)491

24.450 HELP(Form 1-SQL＊FORMS)491

24.451 HELP(Form2-SQL＊PLUS)491

24.452 HEXADECIMAL NOTATION492

24.453 HEXTORAW492

24.454 HIDE_MENU492

24.455 HIDE_PAGE492

24.456 HORIZONTAL SCROLLING(SQL＊FORMS)493

24.457 HORZLBL493

24.458 HORZLEG493

24.459 HORZMAX493

24.460 HORZMIN493

24.461 HOST(Form 1-SQL＊FORMS Version 2,SQL＊PLUS)493

24.462 HOST(Form 2-SQL＊FORMS Versions 3)493

24.463 IAC(SQL＊FORMSS Interactive Application Converter)494

24.464 IAD(SQL＊FORMS)494

24.465 IAG(SQL＊FORMS Interactive Application Generator)494

24.466 IAP(SQL＊FORMS)495

24.467 IF495

24.468 IMP496

24 468.1 Interactive Mode496

24.468.2 USING IMPORT IN Interactive Mode497

24.468.3 Command Line Mode(V6 Only)498

24.468.4 MOVING Data from v5 to v6499

24.468.5 Options within in v6 Export and Import499

24.469 IMPORT499

24.470 IN500

24.471 INDEX500

24.472 INDEX SEGMENT500

24.473 INDICATOR VARIABLE500

24.474 INIT.ORA501

24.475 INITCAP501

24.476 INITIALIZATION502

24.477 INP FILE(SQL＊FORMS)502

24.478 INPUT502

24.479 INPUT ALLOWED502

24.480 INSERT(Form 1-Embedded SQL)502

24.481 INSERT(Form 2-PL/SQL)503

24.482 INSERT(Form 3-SQL Command)503

24.483 INSERT MODE(SQL＊FORMS)504

24.484 INSTANCE504

24.485 INSTANCE IDENTIFIER504

24 486 INSTANCE RECOVERY504

24.487 INSTR504

24.488 INTEGRITY CONSTRAINT505

24.489 INTERSECT505

24.490 IOR PROGRAM505

24.491 IS NULL505

24.492 JOIN505

24.493 JOIN COLUMN506

24.494 JULIAN DATE506

24.495 KERNEL506

24.496 KEY507

24.497 KEYBOARD MAP(SQL＊FORMS)507

24.498 KEYWORD507

24.499 LABEL(SQL＊FORMS)507

24.500 LABELLENGTH507

24.501 LAST_DAY507

24.502 LAST_RECORD507

24.503 LEAF508

24.504 LEAST508

24.505 LEG508

24.506 LENGTH508

24.507 LEVEL508

24.508 LGWR508

24.509 LIKE509

24.510 LINE509

24.511 LINEAPP509

24.512 LINESIZE(SQL＊PLUS)509

24.513 LIST(Form 1-SQL＊FORMS)509

24.514 LIST(Form 2-SQL＊PLUS)509

24.515 LIST FUNCTIONS510

24.516 LIST_VALUES510

24.517 LOADREP510

24.518 LOCAL DATABASE511

24.519 LOCK511

24.520 LOCK_RECORD511

24.521 LOCK TABLE(Form 1-SQL command ORACLE V5)511

24.522 LOCK TABLE(Form 2-SQL or PL/SQL command ORACLE 512 V6)512

24.523 LOG WRITER PROCESS(LGWR)513

24.524 LOGICAL EXPRESSION513

24.525 LOGICAL OPERATOR513

24.525.1 测试单值的逻辑操作符513

24.525.2 测试多于一个值的逻辑操作符513

24.525.3 其他逻辑操作符514

24.526 LOGICAL UNIT OF WORK514

24.527 LOGIN ACCOUNT514

24.528 LOGON ACCOUNT514

24.529 LONG(SQL＊PLUS)514

24.530 LONG DATATYPE514

24.531 LONGRAW DATATYPE514

24.532 LOOP515

24.533 LOWER517

24.534 LPAD517

24.535 LSTEXP517

24.536 LTRIM517

24.537 MACRO(SQL＊FORMS)518

24.538 MAIN MENU(SQL＊FORMS)518

24.539 MAIN QUERY518

24.540 MAINTENANCE RELEASE518

24.541 MANDATORY(SQL＊FORMS)518

24.542 MASTER BLOCK(SQL＊FORMS)518

24.543 MASTER-DETAIL RELATIONSHIP(SQL＊FORMS)518

24.544 MAX518

24.545 MAXDATA(SQL＊PLUS)519

24.546 MEDIA RECOVERY519

24.547 MESSAGE519

24.548 MESSAGE_CODE519

24.549 MESSAGE LINE(SQL＊FORMS)520

24.550 MESSAGE_TEXT520

24.551 MESSAGE_TYPE520

24.552 MIN521

24.553 MINUS521

24.554 MOD521

24.555 MONTHS_BETWEEN522

24.556 MOUNT A DATABASE522

24.557 MOUNT AND OPEN A DATABASE522

24.558 MOVEREP522

24.559 MOVE_VIEW523

24.560 MULTI-RECORD BLOCK523

24.561 MULTIPLE-PROCESS523

24.562 NAME_IN523

24.563 NAMES524

24.564 NESTING524

24.565 NETWORK524

24.566 NEWPAGE(SQL＊PLUS)524

24.567 NEW_FORM524

24.568 NEW_TIME524

24.569 NEXT_BLOCK525

24.570 NEXT_DAY525

24.571 NEXT_FIELD526

24.572 NEXT_KEY526

24.573 NEXT_RECORD526

24.574 NEXT_SET526

24.575 NLSSORT527

24.576 NOAUDIT527

24.577 NODE528

24.578 NON-DISPLAYABLE CHARACTERS528

24.579 NON-EQUI-JOIN528

24.580 NONCOMPRESSED INDEX528

24.581 NOT529

24.582 NULL(FORM 1-PL/SQL)529

24.583 NULL(FORM 2-SQL COLUMN VALUE)529

24.584 NULL(Form 3-SQL＊PLUS)530

24.585 NUMBER DATATYPE530

24.586 NUMBER FORMATS530

24.587 NUMBER FUNCTIONS531

24.588 NUMERIC FIELD(SQL＊FORMS)531

24.589 NUMWIDTH(SQL＊PLUS)531

24.590 NVL532

24.591 OBJECT532

24.592 OBJECT NAMES532

24.593 ODL532

24.594 ODS532

24.595 OFFLINE REDO LOG532

24.596 ON-CLEAR-BLOCK-TRIGGER(SQL＊FORMS)533

24.597 ON-DATABASE RECORD TRIGGER(SQL＊FORMS)533

24.598 ON-DELETE TRIGGER(SQL＊FORMS)533

24.599 ON-ERROR TRIGGER(SQL＊FORMS)533

24.600 ON-LOCK TRIGGER(SQL＊FORMS)533

24.601 ON-MESSAGE TRIGGER(SQL＊FORMS)533

24.602 ON-NEW-FIELD-INSTANCE TRIGGER(SQL＊FORMS)533

24.603 ON-NEW-RECORD TRIGGER(SQL＊FORMS)533

24.604 ON-REMOVE-RECORD TRIGGER(SQL＊FORMS)533

24.605 ON-UPDATE TRIGGER(SQL＊FORMS)533

24.606 ON-VALIDATE-FIELD TRIGGER(SQL＊FORMS)533

24.607 ON-VALIDATE-RECORD TRIGGER(SQL＊FORMS)533

24.608 ONLINE BACKUP534

24.609 ONLINE REDO LOG534

24.610 OPEN534

24.611 OPEN CURSOR(Embedded SQL)534

24.612 OPEN DATABASE535

24.613 OPERATING SYSTEM535

24.614 OPERATOR535

24.615 OPERATOR(SQL＊FORMS)535

24.616 OPS＄ LOGINS536

24.617 OPTIMIZER536

24.618 OPTION(SQL＊FORMS)536

24.619 OR536

24.620 ORACLE DATA LOADER(ODL)536

24.621 ORACLE DISPLAY SYSTEM(ODS)536

24.622 ORACLE PROGRAM INTERFACE(OPI)536

24.623 ORDER BY536

24.624 OTHER FUNCTIONS537

24.625 OUTER JOIN537

24.626 PACKAGED FUNCTIONS538

24.627 PACKAGED PROCEDURES538

24.628 PAGE539

24.629 PAGESIZE(SQL＊PLUS)539

24.630 PARAMETER539

24.631 PARAMETERS539

24.632 PARENT540

24.633 PARENT QUERY540

24.634 PARENTHESES540

24.635 PARSE540

24.636 PARTITION540

24.637 PASS NUMBER540

24.638 PASSWORD541

24.639 PAT541

24.640 PATPIE541

24.641 PATTERN541

24.642 PAUSE(Form1-SQL＊FORMS)541

24.643 PAUSE(Form2-SQL＊PLUS)541

24.644 PAUSE(Form3-SQL＊PLUS)541

24.645 PCTFREE542

24.646 PCTUSED542

24.647 PHYSICAL BLOCK542

24.648 PIE542

24.649 PL/SQL Key Words and Symbols542

24.650 PMON PROCESS544

24.651 POP-UP WINDOW(SQL＊FORMS)544

24.652 POST544

24.653 POST-BLOCK TRIGGER(SQL＊FORMS)544

24.654 POST-CHANGE TRIGGER(SQL＊FORMS)544

24.655 POST-COMMIT TRIGGER(SQL＊FORMS)544

24.656 POST-FIELD TRIGGER(SQL＊FORMS)544

24.657 POST-FORM TRIGGER(SQL＊FORMS)544

24.658 POST-INSERT TRIGGER(SQL＊FORMS)545

24.659 POST-QUERY TRIGGER(SQL＊FORMS)545

24.660 POST-RECORD TRIGGER(SQL＊FORMS)545

24.661 POST-UPDATE TRIGGER(SQL＊FORMS)545

24.662 POWER545

24.663 PRAGMA545

24.664 PRE-BLOCK TRIGGER(SQL＊FORMS)545

24.665 PRE-COMMIT TRIGGER(SQL＊FORMS)545

24.666 PRE-DELETE TRIGGER(SQL＊FORMS)545

24.667 PRE-FILED TRIGGER(SQL＊FORMS)546

24.668 PRE-FILED TRIGGER(SQL＊FORMS)546

24.669 PRE-INSERT TRIGGER(SQL＊FORMS)546

24.670 PRE-QUERY TRIGGER(SQL＊FORMS)546

24.671 PRE-RECORD TRIGGER(SQL＊FORMS)546

24.672 PRE-UPDATE TRIGGER(SQL＊FORMS)546

24.673 PROCEDENCE546

24.674 PRECOMPILER547

24.675 PREDICATE547

24.676 PREPARE(Embedded SQL)547

24.677 PREVIOUS_BLOCK548

24.678 PREVIOUS_FIELD548

24.679 PREVIOUS_RECORD548

24.680 PRIMARY KEY548

24.681 PRIMARY KEY FIELD(SQL＊FORMS)549

24.682 PRINT549

24.683 PRINTDEF549

24.684 PRIOR549

24.685 PRIVILEGE549

24.686 PRO＊ADA549

24.687 PRO＊C549

24.688 PRO＊COBOL550

24.689 PRO＊FORTRAN550

24.690 PRO＊PASCAL550

24.691 PRO＊PL/I550

24.692 PROCEDURE(SQL＊FORMS）550

24.693 PRODUCT_USER_PROFILE550

24.694 PROPAGATION(SQL＊FORMS)550

24.695 PSEUDO-COLUMNS550

24.696 PUBLIC551

24.697 PUBLIC SYNONYM551

24.698 QUERY551

24.699 QUERY LENGTH(SQL＊FORMS)551

24.700 QUERY MODE(SQL＊FORMS)551

24.701 QUERY OPERATORS552

24.702 QUERY TRIGGER(SQL＊FORMS)552

24.703 QUIT552

24.704 QUOTA552

24.705 RAISE552

24.706 RAW DATATYPE553

24.707 RAWTOHEX553

24.708 RDBMS553

24.709 READ CONSISTENCY553

24.710 RECORD553

24.711 RECORD LOCKING553

24.712 RECSEP(SQL＊PLUS)553

24.713 RECSEPCHAR(SQL＊PLUS)554

24.714 RECURSIVE CALLS554

24.715 REDISPLAY554

24.716 REDO LOG554

24.717 REDO LOG SEQUENCE NUMBER554

24.718 REFERENTIAL INTEGRITY554

24.719 REFERENTIAL INTEGRITY RULE554

24.720 RELATION554

24.721 RELATIONAL DATABASE MANAGEMENT SYSTEM555

24.722 RELATIONAL OPERATOR555

24.723 REMARK555

24.724 REMOTE COMPUTER555

24.725 REMOTE DATABSE555

24.726 RENAME555

24.727 REPEATABLE READ556

24.728 REPLACE556

24.729 REPLACE MODE(SQL＊FORMS)556

24.730 REPLACE_MENU556

24.731 RESERVED WORDS556

24.732 RESIZE_VIEW564

24.733 RESOURCE565

24.734 RETRIEVE(SQL＊FORMS)565

24.735 REVOKE(Form 1-ORACLE V5 and V6)565

24.737 REVOKE(Form 2-ORACLE V6 Only)565

24.738 REVOKE(Form 3-ORACLE V5 and V6)566

24.739 ROLL FORWARD566

24.740 ROLLBACK566

24.741 ROLLBACK(Form 1-ORACLE V5)567

24.742 ROLLBACK(Form 2-DRACLE V6)567

24.743 ROLLBACK(Form 3-Embedded SQL)567

24.744 ROLLBACK SEGMENT568

24.745 ROOT568

24.746 ROUND(Form 1-for Dates)568

24.746.1 Formats Available for Rounding568

24.747 ROUND(Form 2-for Numbers)569

24.748 ROW569

24.749 ROW-HEADER569

24.750 ROW-LEVEL LOCK MANAGER570

24.751 ROW-LEVEL LOCKING570

24.752 ROW PIECE570

24.753 ROW SEQUENCE NUMBER570

24.754 ROWID570

24.755 ROWIDTOCHAR570

24.756 ROWNUM571

24.757 RPAD571

24.758 RTRIM571

24.759 RUN572

24.760 RUNFORM572

24.761 RUNMENU573

24.762 RUNREP574

24.763 SAVE576

24.764 SAVEPOINT576

24.765 SCAN(SQL＊PLUS)578

24.766 SCOPE(SQL＊FORMS)578

24.767 SCREEN578

24.768 SCREEN PAINTER(SQL＊FORMS)578

24.769 SCROLL_DOWN578

24.770 SCROLL_UP578

24.771 SEARCH CRITERIA(SQL＊FORMS)579

24.772 SEGMENT579

24.773 SEGMENT HEADER BLOCK579

24.774 SELECT(SQL＊FORMS)579

24.775 SELECT(Form1-SQL)579

24.775.1 其他注意事项：581

24.776 SELECT(Form2-Embedded SQL)581

24.777 SELECT...INTO582

24.778 SEQUENCE583

24.779 SERVER PROCESS583

24.780 SERVER SYSTEM584

24.781 SESSION584

24.791 SET584

24.783 SET CONDITION590

24.784 SET GRAPH590

24.785 SET OPERATOR593

24.786 SET TRANSACTION593

24.787 SET_FIELD594

24.788 SGA594

24.789 SHARE LOCK594

24.790 SHARE-MODE LOCKING594

24.791 SHARE-UPDATE LOCK594

24.792 SHARED PARTITION SYSTEM594

24.793 SHOW595

24.894 SHOW KEYS595

24.895 SHOW MENU595

24.896 SHOW PAGE596

24.897 SHOWMODE(SQL＊PLUS)596

24.898 SHUT DOWN596

24.899 SIGN596

24.800 SINGLE PROCESS596

24.801 SINGLE-RECORD BLOCK(SQL＊FORMS)596

24.802 SMON596

24.803 SOUNDEX597

24.804 SPACE(SQL＊PLUS)597

24.805 SPACE DEFINITION597

24.806 SPLIT SCREEN SCROLLING(SQL＊FORMS)597

24.807 SPOOL597

24.808 SQL598

24.809 SQL COMMUNICATIONS AREA(SQL＊FORMS)598

24.810 SQL CURSOR598

24.811 SQL＊DBA598

24.812 SQL＊FORMS CHANGES598

24.812.1 过程：599

24.812.2 第2版的改进：599

24.8123 第3版升级：600

24.812.4 新的变量：602

24.812.5 其他特征：603

24.813 SQL＊FORMS COMMAND(SQL＊FORMS)603

24.814 SQL＊GRAPH603

24.815 SQL＊LOADER603

24.816 SQL＊MENU603

24.817 SQL＊NET603

24.818 SQL＊PLUS603

24.819 SQL＊REPORTWRITER603

24.820 SQLCA(SQL＊FORMS)604

24.821 SQLCASE(SQL＊PLUS)604

24.822 SQLCODE604

24.823 SQLCONTINUE(SQL＊PLUS)605

24.824 SQLERRM605

24.825 SQLFORMS(SQL＊FORMS Designer)605

24.826 SQLLOAD606

24.826.1 OPTIONS：608

24.826.2 控制文件：608

24.826.3 控制文件格式：608

24.826.4 指定数据文件：609

24.826.5 指定缺省表的装载方法：610

24.826.6 最大的记录长度：610

24.826.7 建立逻辑记录：610

24.826.8 要装载的表（The Tables to be Loaded）：611

24.826.9 结束和关闭记录中的域：611

24.826.10 定义列612

24.826.11 定义数据类型613

24.826.12 有条件地或完全地将某列设置为NULL616

24.826.13 有条件地将某数值列设置为零616

24.827 SQL＊MENU616

24.828 SQL＊MENU Changes617

24.828.1 紧缩过程618

24.828.2 与出错有关的紧缩过程619

24.828.3 宏指令不能用紧缩过程替代619

24.828.4 消去的语言参数620

24.829 SQLNUMBER(SQL＊PLUS)620

24.830 SQLPLUS620

24.831 SQLPREFIX(SQL＊PLUS)621

24.832 SQLPROMPT(SQL＊PLUS)621

24.833 SQLREP621

24.834 SQLTERMINATOR(SQL＊PLUS)623

24.835 SQRT623

24.836 START623

24.837 START UP624

24.838 STATEMENT624

24.839 STATUS LINE(SQL＊FORMS)624

24.840 STDDEV624

24.841 STEP(SQL＊FORMS)624

24.842 STK624

24.843 STORAGE(Form1)625

24.844 STORAGE（Form2-ORACLE第6版）625

24.845 STRUCTURD QUERY LANGUAGE（结构查询语言）626

24.846 SUBQUERY（子查询）626

24.847 SUBSTITUTION627

24.848 SUBSTR627

24.849 SUCCESS(SQL＊FORMS)627

24.850 SUCCESS LABEL(SQL＊FORMS)627

24.851 SUFFIX(SQL＊PLUS)627

24.852 SUM627

24.853 SWITCH(SQL＊FORMS)628

24.854 SYNCHRONIZE628

24.855 SYNCHRONOUS TERMINAL628

24.856 SYNONYM628

24.857 SYNTAX628

24.858 SYNTAX OPERATORS628

24.859 SYS(ORACLE USER)629

24.860 SYSDATE629

24.861 SYSTEM(ORACLE PARTITION OR TABLESPACE)629

24.862 SYSTEM(ORACLE USER)629

24.863 SYSTEM GLOBAL AREA(SGA)630

24.864 SYSTTEM PRIVILEGED SQL＊DBA COMMANDS630

24.865 SYSTEM VARIABLES（系统变量）630

24.866 TABLE631

24.867 TABLE ALIAS631

24.868 TABLE COLUMN631

24.869 TABLE CONSTRAINT631

24.870 TABLE DEFINITION LOCKS631

24.871 TABLE LOCKS632

24.872 TABLE LOOK-UP FIELD(SQL＊FORMS)632

24.873 TABLESPACE632

24.874 TABLESPACE LOCKS632

24.875 TEMPORARY DATA FIELDS(SQL＊FORMS)632

24.876 TEMPORARY SEGMENT632

24.877 TEMPORARY TABLES632

24.878 TERMINAL DEFINITION632

24.879 TERMINAL NODE633

24.880 TERMINATOR633

24.881 TERMDEF633

24.882 TERMOUT(SQL＊PLUS)633

24.883 TIME(SQL＊PLUS)633

24.884 TIME STAMP(SQL＊FORMS)633

24.885 TIMING(Form 1-SQL＊PLUS)634

24.886 TIMING(Form 2-SQL＊PLUS)634

24.887 TO_CHAR634

24.888 TO_DATE635

24.889 TO_NUMBER635

24.890 TPS636

24.891 TRANSACTION636

24.892 TRANSACTION(SQL＊FORMS)636

24.893 TRANSACTION LOCK636

24.894 TRANSACTION PROCESSING636

24.895 TRANSLATE636

24.896 TREE-STRUCTURED QUERY637

24.897 TRIGGER(SQL＊FORMS)637

24.898 TRIGGERS637

24.898.1 Key TRIGGERS637

24.898.2 ON TRIGGERS639

24.898.3 POST Triggers:640

24.898.4 PRE Triggers640

24.898.5 USER-NAMED TRIGGER:641

24.898.6 过程641

24.899 TRIMOUT(SQL＊PLUS)641

24.900 TRUNC(FORM 1-for Dates)641

24.901 TRUNC(Form 2-for Numbers)642

24.902 TTITLE643

24.903 TUPLE643

24.904 TXTQUAL644

24.905 UFI644

24.906 UID644

24.907 UNDEFINE644

24.908 UNDERLINE(SQL＊PLUS)644

24.909 UNION644

24.910 UNIQUE INDEX645

24.911 UNIQUE KEY645

24.912 UNIQUENESS(SQL＊FORMS)645

24.913 UNIT OF WORK645

24.914 UP645

24.915 UPDATE(Form 1-Embedded SQL)645

24.916 UPDATE(Form 2-PL/SQL)646

24.917 UPDATE(Form 3-SQL Iommand)647

24.918 UPDATE ALLOWED(SQL＊FORMS)648

24.919 UPDATE IF NULL(SQL＊FORMS)648

24.920 UPDATE TRIGGER(SQL＊FORMS)648

24.921 UPPER648

24.922 UPPERCASE(SQL＊FORMS)649

24.923 USED EXTENTS649

24.924 USER649

24.925 USER_EXIT649

24.926 USER-FRIENDLY INTERFACE(UFI)649

24.927 USER-NAMED TRIGGER(SQL＊FORMS)649

24.928 USER PROGRAM INTERFACE(UPI)649

24.929 USER VARIABLES650

24.930 USERENV650

24.931 USERNAME650

24.932 VALIDATE INDEX650

24.933 VALIDATION(SQL＊FORMS)650

24.934 VALUE(SQL＊FORMS)650

24.935 VARIABLE PARAMETERS651

24.936 VARIABLE REFERENCES651

24.937 VARIABLES651

24.938 VARIANCE651

24.939 VERIFY(SQL＊PLUS)652

24.940 VERSION NUMBER652

24.941 VERTLBL652

24.942 VERTLEG652

24.943 VERTMAX652

24.944 VERTMIN652

24.945 VIEW652

24.946 VIRTUAL COLUMN652

24.947 VSIZE652

24.948 WALKING A TREE653

24.949 WARM START653

24.950 WHENEVER(Form 1-Embedded SQL)653

24.951 WHENEVER SQLERROR(From2-SQL＊PLUS)654

24.952 WHERE655

24.953 WHILE In PL/SQL656

24.954 WINDOW(SQL＊FORMS)656

24.955 WORK SPACE(SQL＊FORMS)656

24.956 WRAP(SQL＊PLUS)656

24.957 WRAPPING656

附录A 本书中所用到的表657

A.1 ACTIVITY.SQL启动文件657

A.2 MATH.SQL启动文件658

A.3 地址表661

A.4 ASOF表661

A.5 BIRTHDAY表662

A.6 BREEDING表662

A.7 COMFORT表662

A.8 COMMA表663

A.9 EMPTY表663

A.10 HOCKEY表663

A.11 HOLIDAY表654

A.12 LEDGER表665

A.13 LOCATION表674

A.14 LODGING表675

A.15 MAGAZING表675

A.16 MATH表675

A.17 NAME表676

A.18 NEWSPAPER表676

A.19 NUMBERTEST表676

A.20 PAY表677

A.21 RAYDAY表677

A.22 PROSPECT表677

A.23 ROSE表678

A.24 SHIPPING表678

A.25 SKILL表678

A.26 STOCK表679

A.27 TROUBLE表680

A.28 TWONAME表680

A.29 WEATHER表680

A.30 WORKER表681

A.31 WORKERSKILL表681