OCA Oracle Database SQL Certified Expert Exam GuideOCA Oracle数据库SQL认证专家考试指南.doc

OCA Oracle Database SQL Expert Exam Guide (Exam 1Z0-047) - SQL Scripts Reference and Workbook Author: Steve OHearn NOTE: This document is intended to be published as an electronic document.  How to Use This Document This document is intended to be published as an electronic document. This document is a supplement to the book OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047, by Steve OHearn. It is designed to assist those readers wishing to perform hands-on work using the SQL scripts in the book. The chapters in this document correspond to the chapters in the book OCA Oracle Database SQL Expert Exam Guide: Exam 1Z0-047. For each chapter, this document contains the following: Instructions for installing database objects for that chapter, if required Electronic copies of each SQL script specified in the book, by chapter and page number Instructions and notes pertaining to unusual situations, such as SQL scripts that are deliberately written to create an error message, or interim setup scripts required to continue through the scripts in the given chapter. Using this document, a reader may choose to do any of the following: Pick any random chapter of the book, look up the corresponding chapter in this document, and starting at the beginning of that selected chapter in this document, perform the specified SETUP instructions, then continue through the scripts in the chapter. Start at beginning of the book and work through each chapter to the very end. Play what-if games using any scripts found herein, as desired. This document is certainly not needed to get the most out of the book. But Im making it available to you as one of the many tools you may wish to use in your journey toward earning and maintaining your status as an Oracle certified SQL Expert. If you have any questions or comments, please do not hesitate to contact me at soh@ - I love hearing from readers and look forward to hearing from you! In the meantime, good luck and best wishes for great