Amazon no longer offers textbook rentals. We do!

Oracle9i: SQL, with an Introduction to PL/SQL

by: Morris-Murphy, Lannes

Oracle9i: SQL, with an Introduction to PL/SQL

by: Morris-Murphy, Lannes

ISBN 13:
9780619212841
ISBN 10:
0619212845
Edition: 1st
Format: Paperback
Copyright: 07/16/2003
Publisher: Course Technology

Rent From $135.43

New From $188.10

List Price $190.00 Save

Rent $135.43

TERM	PRICE	DUE
SEMESTER	$150.48	Aug 02
QUARTER	$142.96	Jul 17
SHORT TERM	$135.43	Jun 07

Added Benefits of Renting

Free Shipping Both Ways
Highlight/Take Notes Like You Own It
Purchase/Extend Before Due Date

Add to Cart

List Price $190.00 Save $1.90

New $188.10

Usually Ships in 24-48 Hours

We Buy This Book Back!

Included with your book

Free Shipping On Every Order

Add to Cart

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

Prepares students for the first exam in both the Oracle DBA and Internet Application Developer Certification Tracks, and offers a solid general understanding of Oracle9i SQL.

PREFACE

CHAPTER ONE Overview of Database Concepts

(20)

Database Terminology

(1)

Review of Database Design

(8)

Entity-Relationship (E-R) Model

(2)

Database Normalization

(3)

Linking Tables Within the Database

(2)

JustLee Books' Database Description

(3)

Basic Assumptions

(1)

Tables Within JustLee Books' Database

(2)

Structured Query Language (SQL)

(1)

Chapter Summary

(1)

Review Questions

(1)

Multiple Choice

(3)

Hands-on Assignments

(1)

A Case for Oracle9i

(1)

CHAPTER TWO Basic SQL SELECT Statements

(26)

SELECT Statement Syntax

(7)

Selecting All Data in a Table

(1)

Selecting One Column from a Table

(2)

Selecting Multiple Columns from a Table

(2)

Operations Within the SELECT Statement

(7)

Using Column Aliases

(2)

Using Arithmetic Operations

(1)

Using DISTINCT and Unique

(1)

Creating Concatenation

(3)

Chapter Summary

(1)

Chapter 2 Syntax Summary

(1)

Review Questions

(1)

Multiple Choice

(4)

Hands-on Assignments

(1)

A Case for Oracle9i

(2)

CHAPTER THREE Restricting Rows and Sorting Data

(34)

WHERE Clause Syntax

(3)

Rules for Character Strings

(1)

Rules for Dates

(1)

Comparison Operators

(8)

BETWEEN... AND Operator

(1)

IN Operator

(1)

LIKE Operator

(2)

Logical Operators

(3)

Treatment of NULL Values

(1)

ORDER BY Clause Syntax

(5)

Secondary Sort

(1)

Sorting by SELECT Order

(1)

Editing in SQL*Plus

(3)

Chapter Summary

(2)

Chapter 3 Syntax Summary

(2)

Review Questions

(1)

Multiple Choice

(5)

Hands-on Assignments

(1)

A Case for Oracle9i

(1)

CHAPTER FOUR Joining Multiple Tables

(42)

Cartesian Joins

(3)

Cartesian Join-Traditional Method

(2)

Cartesian Join JOIN Method

(1)

Equality Joins

(7)

Equality Joins-Traditional Method

(3)

Equality Joins JOIN Method

(4)

Non-Equality Joins

(3)

Non-Equality Joins-Traditional Method

(2)

Non-Equality Joins JOIN Method

(1)

Self-Joins

(1)

Self-Joins-Traditional Method

(1)

Self-Joins-JOIN Method

(1)

Outer Joins

(5)

Outer Joins-Traditional Method

(1)

Outer Joins JOIN Method

100

(2)

Set Operators

102

(4)

Joining Three or More Tables

106

(3)

Joining Three or More Tables-Traditional Method

106

(1)

Joining Three or More Tables JOIN Method

107

(2)

Chapter Summary

109

(2)

Chapter 4 Syntax Summary

111

(3)

Review Questions

114

(1)

Multiple Choice

114

(6)

Hands-on Assignments

120

(1)

A Case for Oracle9i

121

(2)

CHAPTER FIVE Selected Single-Row Functions

123

(38)

Case Conversion Functions

124

(3)

LOWER Function

124

(2)

UPPER Function

126

(1)

INITCAP Function

126

(1)

Character Manipulation Functions

127

(6)

SUBSTR Function

127

(2)

LENGTH Function

129

(1)

LPAD and RPAD Functions

130

(1)

LTRIM and RTRIM Functions

131

(1)

REPLACE Function

132

(1)

CONCAT Function

132

(1)

Number Functions

133

(3)

ROUND Function

133

(2)

TRUNC Function

135

(1)

Date Functions

136

(4)

MONTHS_BETWEEN Function

137

(1)

ADD_MONTHS Function

137

(1)

NEXT_DAY Function

138

(1)

TO_DATE Function

139

(1)

Other Functions

140

(8)

NVL Function

140

(2)

NVL2 Function

142

(1)

TO_CHAR Function

143

(3)

DECODE Function

146

(1)

SOUNDER Function

147

(1)

Nesting Functions

148

(1)

DUAL Table

149

(2)

Chapter Summary

151

(1)

Chapter 5 Syntax Summary

152

(2)

Review Questions

154

(1)

Multiple Choice

155

(4)

Hands-on Assignments

159

(1)

A Case for Oracle9i

160

(1)

CHAPTER SIX Group Functions

161

(28)

Group Function Concepts

162

(11)

SUM Function

163

(2)

AVG Function

165

(1)

COUNT Function

166

(2)

MAX Function

168

(1)

MIN Function

169

(1)

GROUP BY Clause

170

(3)

HAVING Clause

173

(2)

Nesting Functions

175

(1)

Statistical Group Functions

176

(3)

STDDEV Function

176

(1)

VARIANCE Function

177

(2)

Chapter Summary

179

(1)

Chapter 6 Syntax Summary

179

(2)

Review Questions

181

(1)

Multiple Choice

181

(5)

Hands-on Assignments

186

(1)

A Case for Oracle9i

187

(2)

CHAPTER SEVEN Subqueries

189

(38)

Subqueries and Their Uses

190

(1)

Single-Row Subqueries

191

(6)

Single-Row Subquery in a WHERE Clause

191

(4)

Single-Row Subquery in a HAVING Clause

195

(1)

Single-Row Subquery in a SELECT Clause

196

(1)

Multiple-row Subqueries

197

(9)

IN Operator

197

(1)

ALL and ANY Operators

198

(5)

EXISTS Operator

203

(1)

Multiple-Row Subquery in a HAVING Clause

204

(2)

Multiple-column Subqueries

206

(3)

Multiple-Column Subquery in a FROM Clause

206

(1)

Multiple-Column Subquery in a WHERE Clause

207

(2)

NULL Values

209

(4)

NVL in Subqueries

210

(1)

IS NULL in Subqueries

211

(1)

Correlated Subqueries

211

(2)

Nested Subqueries

213

(2)

Chapter Summary

215

(1)

Chapter 7 Syntax Summary

216

(1)

Review Questions

217

(1)

Multiple Choice

218

(6)

Hands-on Assignments

224

(1)

A Case for Oracle9i

224

(3)

CHAPTER EIGHT Table Creation and Management

227

(32)

Table Design

229

(3)

Table Creation

232

(2)

Defining Columns

232

(2)

Viewing Table Structures: DESCRIBE

234

(1)

Table Creation Through Subqueries

234

(5)

CREATE TABLE...AS

235

(3)

Subqueries with Group Functions

238

(1)

Modifying Existing Tables

239

(20)

ALTER TABLE...ADD Command

240

(1)

ALTER TABLE...MODIFY Command

240

(3)

ALTER TABLE...DROP COLUMN Command

243

(1)

ALTER TABLE...SET UNUSED/DROP UNUSED COLUMNS Command

244

(2)

Renaming a Table

246

(2)

Truncating a Table

248

(1)

Deleting a Table

249

(1)

Chapter Summary

250

(1)

Chapter 8 Syntax Summary

250

(2)

Review Questions

252

(1)

Multiple Choice

252

(4)

Hands-on Assignments

256

(1)

A Case for Oracle9i

257

(2)

CHAPTER NINE Constraints

259

(30)

Creating Constraints

260

(2)

Creating Constraints at the Column Level

261

(1)

Creating Constraints at the Table Level

262

(1)

Using the PRIMARY KEY Constraint

262

(3)

Using the FOREIGN KEY Constraint

265

(3)

Using the UNIQUE Constraint

268

(1)

Using the CHECK Constraint

269

(2)

Using the NOT NULL Constraint

271

(1)

Including Constraints During Table Creation

272

(3)

Viewing Constraints

275

(1)

Disabling and Dropping Constraints

276

(1)

Using DISABLE/ENABLE

276

(1)

Dropping Constraints

277

(1)

Chapter Summary

278

(1)

Chapter 9 Syntax Summary

279

(2)

Review Questions

281

(1)

Multiple Choice

282

(5)

Hands-on Assignments

287

(1)

A Case for Oracle9i

287

(2)

CHAPTER TEN Data Manipulation

289

(32)

Inserting New Rows

290

(9)

INSERT Command

291

(6)

Inserting Data from an Existing Table

297

(2)

Modifying Existing Rows

299

(3)

UPDATE command

299

(3)

Substitution Variables

302

(2)

Transaction Control Statements

304

(2)

COMMIT and ROLLBACK Commands

305

(1)

Deleting Rows

306

(3)

Table Locks

309

(2)

LOCK TABLE command

309

(1)

SELECT... FOR UPDATE Command

310

(1)

Chapter Summary

311

(1)

Chapter 10 Syntax Summary

312

(1)

Review Questions

313

(1)

Multiple Choice

314

(4)

Hands-on Assignments

318

(1)

A Case for Oracle9i

319

(2)

CHAPTER ELEVEN Views

321

(30)

Creating a View

323

(7)

Creating a Simple View

324

(3)

DML Operations on a Simple View

327

(3)

Creating a Complex View

330

(9)

DML Operations on a Complex View with an Arithmetic Expression

331

(2)

DML Operations on a Complex View Containing Data from Multiple Tables

333

(3)

DML Operations on a Complex View Containing Functions or Grouped Data

336

(1)

DML Operations on a Complex View Containing DISTINCT or ROWNUM

337

(1)

Summary Guidelines of DML Operations on a Complex View

338

(1)

Dropping a View

339

(1)

Creating an Inline View

339

(3)

"TOP-N" Analysis

340

(2)

Chapter Summary

342

(1)

Chapter 11 Syntax Summary

343

(1)

Review Questions

343

(1)

Multiple Choice

344

(5)

Hands-on Assignments

349

(1)

A Case for Oracle9i

350

(1)

CHAPTER TWELVE Additional Database Objects

351

(28)

Sequences

353

(8)

Creating a Sequence

353

(5)

Using Sequence Values

358

(2)

Altering Sequence Definitions

360

(1)

Dropping a Sequence

361

(1)

Indexes

361

(5)

Creating an Index

363

(2)

Verifying an Index

365

(1)

Synonyms

366

(3)

Deleting a Synonym

368

(1)

The Data Dictionary

369

(1)

Chapter Summary

370

(2)

Chapter 12 Syntax Summary

372

(1)

Review Questions

373

(1)

Multiple Choice

373

(4)

Hands-on Assignments

377

(1)

A Case for Oracle9i

378

(1)

CHAPTER THIRTEEN User Creation and Management

379

(30)

The Need for Security

381

(2)

Creating a User

383

(2)

Creating User Names and Passwords

383

(1)

Connecting to the Oracle Server

384

(1)

Granting Privileges

385

(8)

Object Privileges

385

(1)

Granting Object Privileges

386

(1)

System Privileges

387

(1)

Granting System Privileges

388

(1)

Deploying GRANT Commands

389

(1)

Changing a User Password

390

(3)

Granting Roles

393

(5)

Viewing Privileges

397

(1)

Revoking and Dropping Privileges and Roles

398

(3)

Revoking Privileges and Roles

398

(2)

Dropping a Role

400

(1)

Dropping a User

400

(1)

Chapter Summary

401

(1)

Chapter 13 Syntax Summary

402

(1)

Review Questions

403

(1)

Multiple Choice

404

(3)

Hands-on Assignments

407

(1)

A Case for Oracle9i

408

(1)

CHAPTER FOURTEEN Formatting Readable Output

409

(34)

The Basic Strategy

410

(1)

COLUMN Command

411

(11)

FORMAT Option

412

(5)

HEADING Option

417

(3)

NULL Option

420

(2)

Environment Variables

422

(6)

Report Headers and Footers

423

(2)

LINESIZE

425

(1)

PAGESIZE

426

(2)

BREAK Command

428

(6)

CLEAR Command

430

(1)

COMPUTE Command

431

(2)

SPOOL Command

433

(1)

Chapter Summary

434

(1)

Chapter 14 Syntax Summary

435

(2)

Review Questions

437

(1)

Multiple Choice

437

(5)

Hands-on Assignments

442

(1)

A Case for Oracle9i

442

(1)

CHAPTER FIFTEEN Introduction to PL/SQL

443

(32)

Basic Structure

445

(3)

Declarative Section

448

(4)

Variable Names

449

(1)

Constants

449

(1)

PL/SQL Datatypes

449

(2)

NOT NULL Constraint

451

(1)

Variable Initialization

451

(1)

Executable Section

452

(4)

SELECT Statement

452

(1)

DML Statements in PL/SQL

453

(3)

Execution Control

456

(3)

IF Statements

456

(3)

Iterative Control

459

(5)

Basic Loop

459

(2)

FOR Loop

461

(1)

WHILE Loop

462

(1)

Nested Loops

463

(1)

Chapter Summary

464

(1)

Chapter 15 Syntax Summary

465

(3)

Review Questions

468

(1)

Multiple Choice

468

(4)

Hands-on Assignments

472

(1)

A Case for Oracle9i

473

(2)

CHAPTER SIXTEEN Cursors and Exceptions

475

(26)

Cursors

476

(12)

Declaring an Explicit Cursor

477

(1)

Opening an Explicit Cursor

478

(1)

Closing the Cursor

479

(1)

Fetching Data from the Cursor

479

(4)

Cursor FOR Loop

483

(3)

Cursor Loop Control with Logical Operators

486

(2)

Exception Handling

488

(4)

User-Defined Exception Handling

490

(2)

Chapter Summary

492

(1)

Chapter 16 Syntax Summary

493

(1)

Review Questions

494

(1)

Multiple Choice

495

(3)

Hands-on Assignments

498

(1)

A Case for Oracle9i

499

(2)

APPENDIX A

501

(6)

Tables for the JustLee Books Database

501

(22)

CUSTOMERS Table

501

(1)

BOOKS Table

502

(1)

ORDERS Table

502

(1)

ORDERITEMS Table

503

(1)

AUTHOR Table

504

(1)

BOOKAUTHOR Table

505

(1)

PUBLISHER Table

506

(1)

PROMOTION Table

506

(1)

APPENDIX B SQL Syntax Guide

507

(16)

APPENDIX C

523

(27)

Oracle9i Practice Exams (A-E)

523

(27)

Practice Exam A

523

(6)

Practice Exam B

529

(6)

Practice Exam C

535

(6)

Practice Exam D

541

(5)

Practice Exam E

546

(4)

APPENDIX D

550

(3)

Oracle Resources

550

(3)

Oracle Academic Initiative (OAJ)

550

(1)

Oracle Certification Program (OCP)

550

(1)

Oracle Technology Network (OTN)

550

(1)

International Oracle Users Group (JOUG)

550

(3)

GLOSSARY

553

(8)

INDEX

561

Amazon no longer offers textbook rentals. We do!

Oracle9i: SQL, with an Introduction to PL/SQL

Oracle9i: SQL, with an Introduction to PL/SQL

9780619212841

0619212845

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Oracle9i: SQL, with an Introduction to PL/SQL

Oracle9i: SQL, with an Introduction to PL/SQL

9780619212841

0619212845

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products