OCP Oracle8i SQl & PL/SQL考试学习指南 英文版PDF格式文档图书下载
- 购买点数:17 点
- 作 者:(美)Jason S.Couchman著
- 出 版 社:北京:机械工业出版社
- 出版年份:2002
- ISBN:711109462X
- 标注页数:570 页
- PDF页数:597 页
Date Functions 60
Conversion Functions 63
Chapter Summary 67
Two-Minute Drill 67
Fill-in-the-Blank Questions 69
Chapter Questions 69
Fill-in-the-Blank Answers 73
Answers to Chapter Questions 73
2 Advanced Data Selection in Oracle 77
Displaying Data from Multiple Tables 78
select Statements That Join Data from More Than One Table 79
Creating Outer Joins 85
Joining a Table to Itself 88
Group Functions and Their Uses 92
Identifying and Using Group Functions 92
Using the group by Clause 96
Excluding group Data with having 102
Using Subqueries 104
Understanding and Defining Subqueries 105
Listing and Writing Different Types of Subqueries 109
Multiple-Column Subqueries 113
Writing Multiple-Column Subqueries 114
NULL Values and Subqueries 116
Subqueries in a from Clause 119
Producing Readable Output with SQL*Plus 122
Entering Variables 123
Customizing SQL*Plus Environments 129
Producing Readable Output 137
Creating and Executing Scripts 142
Saving Customizations 144
Chapter Summary 146
Two-Minute Drill 146
Fill-in-the-Blank Questions 150
Chapter Questions 150
Answers to Chapter Questions 155
Fill-in-the-Blank Answers 155
3 Creating Oracle Database Objects 159
Creating the Tables of an Oracle Database 160
Describing Tables 161
Creating Tables 163
Datatypes and Column Definitions 169
Altering Table Definitions 175
Dropping, Renaming, and Truncating Tables 180
Including Constraints 183
Describing Constraints 184
Creating and Maintaining Constraints 187
The Oracle Data Dictionary 202
Available Dictionary Views 202
Querying the Data Dictionary 209
Manipulating Oracle Data 213
Adding New Rows to a Table 213
Making Changes to Existing Row Data 217
Deleting Data from the Oracle Database 219
The Importance of Transaction Control 220
Chapter Summary 226
Two-Minute Drill 227
Fill-in-the-Blank Questions 230
Chapter Questions 230
Fill-in-the-Blank Answers 235
Answers to Chapter Questions 235
4 Creating Other Database Objects in Oracle 239
Creating Views 240
Creating Simple Views 241
Creating Views That Enforce Constraints 248
Creating Complex Views 252
Modifying and Removing Views 257
Other Database Objects 260
Overview of Other Database Objects 261
Using Sequences 262
Using Indexes 268
Using Public and Private Synonyms 277
User Access Control 280
Creating Users 281
Granting and Revoking Object Privileges 289
Using Roles to Manage Database Access 296
Chapter Summary 302
Two-Minute Drill 303
Fill-in-the-Blank Questions 306
Chapter Questions 306
Answers to Chapter Questions 310
Fill-in-the-Blank Answers 310
5 Introducing PL/SQL 313
Overview of PL/SQL 314
Benefits of PL/SQL 315
Parts of a PL/SQL Block 319
Declaring and Using Variables 327
Executing PL/SQL Code 334
Writing Executable Statements 339
Writing Executable PL/SQL Statements 339
Nesting PL/SQl Blocks 342
Executing and Testing PL/SQL 345
Using Code Conventions 350
Writing Control Structures 352
Constructing an if-then Statement 353
Using Loops 355
Using Logic Tables 361
Using Nested Loops and Labels 364
Two-Minute Drill 368
Chapter Summary 368
Fill-in-the-Blanks 370
Chapter Questions 370
Fill-in-the-Blank Answers 371
Answers to Chapter Questions 371
6 Database Programming with PL/SQL 373
Interacting with the Oracle Database 374
Using select in PL/SQL Code 375
Declaring PL/SQL Variable Types Dynamically 378
Writing DML Statements in PL/SQL 382
Transaction Processing in PL/SQL 385
Determining SQL Statement Outcome 388
Working with Composite Datatypes 391
Creating PL/SQL Records 392
Using %rowtype to Create Records 397
Creating PL/SQL Tables 399
Creating PL/SQL Tables of Records 405
Reviewing PL/SQL Records, Tables, and Tables of Records 408
Using Explicit Cursors 409
Explicit Cursor Handling 409
Using PL/SQL Records to Fetch Data from Cursors 414
Writing cursor for Loops 417
Understanding Advanced Explicit Cursor Concepts 420
Passing Parameters to Explicit Cursors 421
Using the for update and where current of Clauses 423
Using Subqueries in Cursors 426
Error Handling 427
Defining a PL/SQL Exception 428
Trapping Unhandled and Unanticipated Errors 433
Customizing PL/SQL Error Messages 436
Understanding Exception Propagation in Nested Blocks 440
Chapter Summary 444
Two-Minute Drill 444
Fill-in-the-Blanks 446
Chapter Questions 447
Answers to Chapter Questions 451
Fill-in-the-Blank Answers 451
PARTⅡOCP Oracle8i DBA Practice Exams 457
7 OCP Exam I: Introduction to SQL and PL/SQL 457
Practice Exam 1 458
Practice Exam 2 477
Practice Exam 3 500
Answers to Practice Exam 1 517
Answers to Practice Exam 2 530
Answers to Practice Exam 3 544
Index 557
- 《Jave 2认证考试学习指南 (第四版) (英文版)》(美)海勒等著 2004
- 《CCNA学习指南 中文版 640-801 英文版》(美)Todd Lammle著;徐宏等译 2004
- 《Java 2 认证考试学习指南 英文原版》(美)Simon Roberts,(美)Philip Heller,(美)Michael Ernest著 2000
- 《OCP Oracle8i DBA Upgrade考试学习指南 英文版》(美)Jason S.Couchman 2002
- 《OCP Oracle8i SQl & PL/SQL考试学习指南 英文版》(美)Jason S.Couchman著 2002
- 《CCNA INTRO学习指南 中文版 640-821》(美)TODD LAMMLE著;徐宏,程代伟,池亚平译 2007
- 《CCNP BCRAN学习指南 642-821 英文版》(美)帕金(Padjen,R.)著 2004
- 《MCSE学习指南 Windows XP Professional Exam 70-270 英文版》(美)Curt Simmons著 2002
- 《CCNP:BCRAN学习指南 中文版 642-821》(美)Robert Padjen著;王军,王健等译 2004
- 《CCNA学习指南 英文版 640-801》Todd Lammle 2004
- 《用例分析技术》(美)Geri Schneider,(美)Jason P.Winters著;姚淑珍,李巍等译 2002
- 《最富有的女人》(美)波尼·杜克(Pony Duke),(美)简森·托马斯(Jason Thomas)著;崔权醴,王亚军译 1997
- 《DHTML快速充电》(美)Jason Cranford League著;康创译 2000
- 《WCDMA原理与开发设计》(美)Rudolf Tanner, (美)Jason Woodard编著;叶银法等译 2007
- 《使用HTML编制框架》(美)(J.C. 蒂格)(Jason Cranford Teague)著;辛运帷,李哲译 1998
- 《CEO的海军陆战队》(美)詹森·A.桑塔马利雅(Jason A.Santamaria),(美)文森特·马蒂诺(Vincent Martino),(美)埃里克·K.克莱蒙斯(Eric K.Clemons)著;刘胤之,唐果译 2005
- 《.NET框架下电子商务站点建设指南》(美)Jason Bentrum,(美)James Whatley著;智慧东方工作室译 2002
- 《压电陶瓷 美B.贾菲 著》(美)B.贾菲等 1979
- 《如何建立 Internet 站点(第三版)》(美)Jason Coombs Teb Coombs等 1998
- 《中外文学名著宝库 红字 青少版》(美)霍桑著 2005
- 《北京志 工业卷 机械工业志 农机工业志》北京市地方志编纂委员会编 2001
- 《机械工业和机械图书的出版发行 机械工业出版社发行培训教材》陈慧毅,杨少晨编 1988
- 《冷冲模设计》赵孟栋主编 2006
- 《机械工业出版社》慕拉维叶夫著;孔庆复译 1959
- 《北京市立高级工业职业学校机械科毕业学生韩丕纯分数表/韩丕纯毕业证书》 1949
- 《中等职业教育机电类规划教材 机械工业出版社精品教材 机械设计基础 第2版》机械职业教育基础课教学指导委员会机械设计学科组组编;柴鹏飞主编 2006
- 《集知播识春秋录 机械工业出版社 1952-1988.机械科学技术情报研究所 1958-1988》机械科技情报研究所,机械工业出版社编 1988
- 《电线电缆》上海市电缆研究所编 1975
- 《FoxBASE+ 三周通》文忠等编著 1995
- 《FoxBASE+实验指导书》李爱华,王建诚编 1994