OCP Oracle8i SQl & PL/SQL考试学习指南 英文版PDF|Epub|txt|kindle电子书版本网盘下载

OCP Oracle8i SQl & PL/SQL考试学习指南 英文版PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Date Functions60

Conversion Functions63

Chapter Summary67

Two-Minute Drill67

Fill-in-the-Blank Questions69

Chapter Questions69

Fill-in-the-Blank Answers73

Answers to Chapter Questions73

2 Advanced Data Selection in Oracle77

Displaying Data from Multiple Tables78

select Statements That Join Data from More Than One Table79

Creating Outer Joins85

Joining a Table to Itself88

Group Functions and Their Uses92

Identifying and Using Group Functions92

Using the group by Clause96

Excluding group Data with having102

Using Subqueries104

Understanding and Defining Subqueries105

Listing and Writing Different Types of Subqueries109

Multiple-Column Subqueries113

Writing Multiple-Column Subqueries114

NULL Values and Subqueries116

Subqueries in a from Clause119

Producing Readable Output with SQL*Plus122

Entering Variables123

Customizing SQL*Plus Environments129

Producing Readable Output137

Creating and Executing Scripts142

Saving Customizations144

Chapter Summary146

Two-Minute Drill146

Fill-in-the-Blank Questions150

Chapter Questions150

Answers to Chapter Questions155

Fill-in-the-Blank Answers155

3 Creating Oracle Database Objects159

Creating the Tables of an Oracle Database160

Describing Tables161

Creating Tables163

Datatypes and Column Definitions169

Altering Table Definitions175

Dropping, Renaming, and Truncating Tables180

Including Constraints183

Describing Constraints184

Creating and Maintaining Constraints187

The Oracle Data Dictionary202

Available Dictionary Views202

Querying the Data Dictionary209

Manipulating Oracle Data213

Adding New Rows to a Table213

Making Changes to Existing Row Data217

Deleting Data from the Oracle Database219

The Importance of Transaction Control220

Chapter Summary226

Two-Minute Drill227

Fill-in-the-Blank Questions230

Chapter Questions230

Fill-in-the-Blank Answers235

Answers to Chapter Questions235

4 Creating Other Database Objects in Oracle239

Creating Views240

Creating Simple Views241

Creating Views That Enforce Constraints248

Creating Complex Views252

Modifying and Removing Views257

Other Database Objects260

Overview of Other Database Objects261

Using Sequences262

Using Indexes268

Using Public and Private Synonyms277

User Access Control280

Creating Users281

Granting and Revoking Object Privileges289

Using Roles to Manage Database Access296

Chapter Summary302

Two-Minute Drill303

Fill-in-the-Blank Questions306

Chapter Questions306

Answers to Chapter Questions310

Fill-in-the-Blank Answers310

5 Introducing PL/SQL313

Overview of PL/SQL314

Benefits of PL/SQL315

Parts of a PL/SQL Block319

Declaring and Using Variables327

Executing PL/SQL Code334

Writing Executable Statements339

Writing Executable PL/SQL Statements339

Nesting PL/SQl Blocks342

Executing and Testing PL/SQL345

Using Code Conventions350

Writing Control Structures352

Constructing an if-then Statement353

Using Loops355

Using Logic Tables361

Using Nested Loops and Labels364

Two-Minute Drill368

Chapter Summary368

Fill-in-the-Blanks370

Chapter Questions370

Fill-in-the-Blank Answers371

Answers to Chapter Questions371

6 Database Programming with PL/SQL373

Interacting with the Oracle Database374

Using select in PL/SQL Code375

Declaring PL/SQL Variable Types Dynamically378

Writing DML Statements in PL/SQL382

Transaction Processing in PL/SQL385

Determining SQL Statement Outcome388

Working with Composite Datatypes391

Creating PL/SQL Records392

Using %rowtype to Create Records397

Creating PL/SQL Tables399

Creating PL/SQL Tables of Records405

Reviewing PL/SQL Records, Tables, and Tables of Records408

Using Explicit Cursors409

Explicit Cursor Handling409

Using PL/SQL Records to Fetch Data from Cursors414

Writing cursor for Loops417

Understanding Advanced Explicit Cursor Concepts420

Passing Parameters to Explicit Cursors421

Using the for update and where current of Clauses423

Using Subqueries in Cursors426

Error Handling427

Defining a PL/SQL Exception428

Trapping Unhandled and Unanticipated Errors433

Customizing PL/SQL Error Messages436

Understanding Exception Propagation in Nested Blocks440

Chapter Summary444

Two-Minute Drill444

Fill-in-the-Blanks446

Chapter Questions447

Answers to Chapter Questions451

Fill-in-the-Blank Answers451

PARTⅡOCP Oracle8i DBA Practice Exams457

7 OCP Exam I: Introduction to SQL and PL/SQL457

Practice Exam 1458

Practice Exam 2477

Practice Exam 3500

Answers to Practice Exam 1517

Answers to Practice Exam 2530

Answers to Practice Exam 3544

Index557