目 录
Oracle8i/9i.............................................................................................................................................1
第一部分 Oracle SQL*PLUS 基础...................................................................................................93
第一章 Oracle 数据库基础................................................................................................................93
§1.1 理解关系数据库系统（RDBMS）..................................................................................93
§1.1.1 关系模型..................................................................................................................94
§1.1.2 Codd 十二法则........................................................................................................95
§1.2 关系数据库系统（RDBMS）的组成..............................................................................96
§1.2.1 RDBMS 内核...........................................................................................................96
§1.2.2 数据字典概念..........................................................................................................97
§1.3 SQL、SQL*Plus 及 PL/SQL.............................................................................................97
§1.3.1 SQL 和 SQL*PLUS 的差别....................................................................................97
1. SQL（Structured Query Language）............................................................................................97
Enable{[Validate][Novalidate]} { [UNIQUE][PRIMARY KEY]... } ..............................................98
2. SQL*PLUS.....................................................................................................................................98
3. DDL（Data Define Language）..................................................................................................100
Insert.................................................................................................................................................101
§1.3.2 PL/SQL 语言.........................................................................................................101
§1.4 登录到 SQL*PLUS..........................................................................................................102
§1.4.1 UNIX 环境.............................................................................................................102
1. tnsnames.ora 参数文件：.............................................................................................................103
INST1_HTTP =.................................................................................................................................103
EXTPROC_CONNECTION_DATA =.............................................................................................103
S450 =...............................................................................................................................................104
2. listener.ora 参数文件：................................................................................................................104
LISTENER =.....................................................................................................................................104
SID_LIST_LISTENER =..................................................................................................................105
§1.4.2 Windows NT 和 WINDOWS/2000 环境..............................................................107
1. tnsnames.ora 参数文件：.............................................................................................................107
EXTPROC_CONNECTION_DATA.TAIJI.COM.CN =.................................................................107
S450 =...............................................................................................................................................108
2. listener.ora 参数文件：................................................................................................................108
SID_LIST_LISTENER =..................................................................................................................109
Windows NT/2000 字符方式登录步骤：.......................................................................................110
Windows NT/2000 图形方式登录步骤：.......................................................................................110
§1.5 常用 SQL*PLUS 附加命令简介.....................................................................................111
§1.5.1 登录到 SQL*PLUS...............................................................................................112
SQLPLUS [ [logon] | [start] ]...........................................................................................................112
§1.5.2 EXIT 和 QUIT.......................................................................................................113
评论0
最新资源