This book is intended to help you on your exciting path toward obtaining the Oracle8i Certified Database Administrator and Oracle8i Certified Application Developer certifications. Basic knowledge of Oracle sQL and PL/sQL Is an advantage when reading this book but is not mandatory. using this book and a practice database， you can start learning Oracle and pass the IZO-001 test： Introduction to Oracle： sQL and PL/SQL.
Introduetion Assessment Test Chapter l Relational Technology and Simple SQL SELECT Statements Relatlonal Database Systems Characterlstics of a Relatlonal Database Application Development Cycle Oracle's Implementation of RDBMS and ORDBMS Oracle Datatypes Character Datatypes Numerlc Datatypes The Date Datatype LOB Datatypes Other Datatypes Llterals SQL Fundamentals. Operators and Expressions Wrltlng Slmple guerles SELECT Statement Limiting Rows Sorting Rows SQL*Plus: Oracle's Natlve Interface SQL*Plus: Basics Producing More Readable Output Accepting Values at Runtime Summary Key Terms Revlew guestions ATlswers to Review guestlons Chapter 2 Single-Row and Group Functions Single-Row Functions in sgL NULLs and Single-Row Functlons Single-Row Character Functlons Single-Row Numeric Functions Single-Row Date Functions Slngle-Row Converslon Punctions Programmer-Written Slngle-Row Functions Other Single-Row Functlons Group Functions in sgL Group (Multi-row) Functlons Grouping Data with GROUP BY Llmlting Grouped Data with HAVING Nesting Functions Summary Key Terms Review Questions Answers to Review Questions Chapter 3 Joins and Subqueries Multiple Table Queries Equality and Non-Equallty Jolns Caresian Joins Outer Joins Self-Join using Set Operators Subqueries Single-Row and Multiple-Row Subqueries NULL Values in Subqueries Multiple-Column Subqueries Subqueries in the FROM Clause Summary Key Terms Review guestions Answers to Review guestions Chapter 4 Modffying Data and Security DML Statements Inserting Rows into a Table Updating Rows in a Table Deleting Rows from a Table Selecting Rows FOR UPDATE Locking a Table DML Locks in Oracle Transaction Control Transactions Savepoints and Partial Rollbacks Consistency and Transactions Enabling Transaction-Level Consistency Creating and Modifying Users Database-Authenticated User Accounts Externally Authenticated User Accounts Globally Authentlcated User Accounts Creatlng and Alterlng User Accounts Privileges and Roles Creating and Using Roles Object Privileges System Privileges Roles and Role Prlvlleges Asslgning and Rescinding Privileges Privileges and the Data Dictionary Summary Key Terms Review guestions Answers to Review guestions Chapter 5 Creating and Managing Tables and Views Managing Tables Naming Conventions Creating from Another Table Modifying Table Definitions Dropping/ Renaming Tables Managing Views Creating a View Retrieving Data Inserting, Updating, and Deleting Data Dropping a View Summary Key Terms Review guestions Answers to Review guestions Chapter 6 Other Database Objects and the Data Dictionary Other Database Objects Constraints Sequences Indexes Synonyms Procedures and Functions Packages Triggers A guick 'n' Dirty Review of the Data Dictionary Querying the Data Dictionary Summary Key Terms Review guestions Answers to Review guestions Chapter 7 PL/sQL Basics Benefits of PL/sQL The PL/sQL Block Structure Named and Anonymous Blocks Variables and Constants Declaring Variables Assigning Values to Variables Constants Scalar Datatypes LOB Datatypes Operators The Executable Section Executing a Block Control Stuctures Syntax and Usage Labels Labeled Blocks Labeled Loops The GOTO Statement Nested Blocks Summary Key Terms Review guestions Answers to Review guestions Chapter 8 Interacting with the Database Accessing the Database gueries Other DML Statements Transaction Control Statements E3CpliCit Cursors Using Cursors Cursors with Parameters Cursor FOR Loops Subqueries in a Cursor Updating and Deleting in a Cursor Summary Key Terms Review guestions Answers to Review guestions Chapter 9 Working with Composite Datatypes and Collections PL/sQL Records Creating Records Using Records PL/sQL Collections types of Collections Using Collections Summary Key Terms Review guestions Answers to Review guestions Chapter IO Exception Handling Exceptions, Errors, and PL/sQL Raising and Handling Exceptions Raising Exceptions Handling Exceptiorls Exception Propagation Named Exceptions Customizing Exception Handling Declaring Your Own Exceptions Giving Names to Database Errors Numbering Programmer-Defined Errors Summary Key Terms Review guestions Answers to Review guestions Appendix A Practice Exam Answers to Practice Exam Glossary
鄂公網(wǎng)安備 42010302001612號(hào) 