文档介绍：ertPrs8/Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)/O’Hearn/161421-4/
Front Matter
Contents at A Glance
1 Introduction to SQL . . . . . . . . . . . . . . . 1
2 Using DDL Statements to Create and Manage Tables . . . . . . 45
3 Manipulating Data . . . . . . . . . . . . . . . . 93
4 Retrieving Data Using the SQL ­SELECT Statement . . . . . . 137
5 Restricting and Sorting Data . . . . . . . . . . . . . 169
6 Using Single-Row Functions to ­Customize Output . . . . . . . . . . . . 209
7 Reporting ­Aggregated Data ­Using the Group Functions . . . . . 275
8 Displaying Data from Multiple ­Tables . . . . . . . . . . 311
9 Retrieving Data Using Subqueries . . . . . . . . . . . 345
10 Creating Other Schema Objects . . . . . . . . . . . . 381
11 Managing Schema Objects . . . . . . . . . . . . . 423
12 Using the Set ­Operators . . . . . . . . . . . . . . 487
13 ­Generating Reports­ by Grouping­ Related­ Data . . . . . . . . 511
14 Managing ­Objects with Data Dictionary­ Views . . . . . . . . 533
15 Manipulating Large Data Sets . . . . . . . . . . . . 559
16 Hierarchical ­Retrieval . . . . . . . . . . . . . . . 615
17 Regular ­Expression Support . . . . . . . . . . . . . 639
18 Controlling User Access . . . . . . . . . . . . . . 673
A About the CD . . . . . . . . . . . . . . . . . 709
Glossary . . . . . . . . . . . . . . . . . . . 713
Index. . . . . . . . . . . . . . . . . . . . 729
ix
ertPrs8/Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)/O’Hearn/161421-4/
Front Matter
Contents
Acknowledgments . . . . . . . . . . . . . . . . . . . . xxiii
Preface . . . . . . . . . . . . . . . . . . . . . . . xxv
Introduction . . . . . . . . . . . . . . . . . . . . . . xxix
1 Introduction to SQL ............................ 1
The Exam: An Overview .................................. 2
“SQL Fundamentals I” Versus “SQL Expert” .............. 4
What to Expect ................................... 10