The only guide you need for Oracle8i DBA SQL and PL/SQL exam success You're holding in your hands the most comprehensive and effective guide available for the first exam on the Oracle8i DBA track. An outstanding team of database professionals and trainers delivers crystal-clear explanations of every topic covered on the exam, highlighting critical concepts and offering hands-on tips that can help you in your real-world DBA career. Get complete coverage of SQL and PL/SQL exam objectives\ \...
The only guide you need for Oracle8i DBA SQL and PL/SQL exam success You're holding in your hands the most comprehensive and effective guide available for the first exam on the Oracle8i DBA track. An outstanding team of database professionals and trainers delivers crystal-clear explanations of every topic covered on the exam, highlighting critical concepts and offering hands-on tips that can help you in your real-world DBA career. Get complete coverage of SQL and PL/SQL exam objectivesGet a handle on Oracle database basicsRetrieve data using basic SQL statementsFind out how to use single and multi-row functionsDelve into advanced select statementsCreate and manage Oracle database objectsGet in-depth explanations of security configurationsUnderstand PL/SQL basicsTake control of program execution in PL/SQLMaster PL/SQL database interactionsHandle errors and exceptions in PL/SQLGet the scoop on stored programsTest-Prep Tools on CD-ROMHungry Minds test engine powered by top-rated Boson SoftwareTrial versions of Knowledge Base for Active PL/SQL and ER/Studio Rapid SQL and the Introduction to Oracle: SQL and PL/SQL Prep ExamPlus an e-version of the bookSystem Requirements: PC running Windows NT Service Pack 4 or later; 64 MB RAM.
PrefaceAcknowledgmentsPt. IThe Oracle SQL Language1Ch. 1The Oracle Database3Ch. 2Retrieving Data Using Basic SQL Statements35Ch. 3Using Single- and Multi-Row Functions89Ch. 4Advanced SELECT Statements139Ch. 5Adding, Updating, and Deleting Data191Pt. IIManaging Database Objects225Ch. 6The SQLPlus Environment227Ch. 7Creating and Managing Oracle Database Objects267Ch. 8Configuring Security in Oracle Databases359Pt. IIIUsing PL/SQL401Ch. 9Introduction to PL/SQL403Ch. 10Controlling Program Execution in PL/SQL443Ch. 11Interacting with the Database Using the PL/SQL479Ch. 12Handling Errors and Exceptions in PL/SQL533Ch. 13Introduction to Stored Programs571App. A: What's on the CD-ROM?615App. B: Practice Exam621App. C: Objective Mapping653App. D: Exam Tips665App. E: Database Schema for Labs669App. F: Data Dictionary Views687App. G: Suggested Readings, Web Sites, and Other Resources717Index721End-User License Agreement741CD-ROM Installation Instructions744