"Oracle8 Black Book" contains everything an Oracle professional needs to know about using the object-oriented features included in Oracle8. The CD-ROM contains a "lite" version of the Oracle Administrator program from RevealNet, Inc., tailored exclusively for this book.

Oracle professionals can use this book to quickly learn the features of the latest Oracle release. "Oracle8 PL/SQL Black Book" presents the formal syntax, usage, and actual examples for every declaration, command, and error handler. The CD-ROM features all the source code and examples from the book, plus a demo version of Oracle8 for Windows 95.

Pascavage, a senior Oracle DBA, covers how to use Oracle8's connection manager, and provides information on the Advanced Network option with examples of both client and server configuration net files for Net8. An excellent troubleshooting guide, this guide also features exam questions with detailed explanations of answers and a complete test review.

This guide supplies insights to developers on backup and recovery issues and methodologies, provides practice questions accompanied by fully explained answers, and serves as a troubleshooting guide. Readers get proven test-taking strategies, tips on handling trick questions, a "cram sheet" for last-minute review, and information on third-party resources.

Teaching architectural differences, as they pertain to Oracle, between Unix and Windows NT, this book describes Oracle-supplied, NT-specific utilities in detail, including the NT Instance Manager, NT Backup Manager, NT Recovery Manager, and SQL Net Easy Configuration. It covers installing Oracle Enterprise Manager, building the OEM repository, creating the OEM network definition, and configuring the intelligent agents. The CD-ROM includes sample database administration scripts.

Containing information previously available only in training materials from Oracle, this guide condenses the curriculum to focus on what's necessary to pass the exam. Readers can practice answering questions, get comprehensive explanation of answers, learn how to handle trick questions, and can tear out a "cram sheet" to prep right before the exam.

The cult-y pocket-size field guide to the strange and intriguing secrets of the Mojave—its myths and legends, outcasts and oddballs, flora, fauna, and UFOs—becomes the definitive, oracular book of the desert For the past five years, Desert Oracle has existed as a quasi-mythical, quarterly periodical available to the very determined only by subscription or at the odd desert-town gas station or the occasional hipster boutique, its canary-yellow-covered, forty-four-page issues handed from one curious desert zealot to the next, word spreading faster than the printers could keep up with. It became a radio show, a podcast, a live performance. Now, for the first time—and including both classic and new, never-before-seen revelations—Desert Oracle has been bound between two hard covers and is available to you. Straight out of Joshua Tree, California, Desert Oracle is “The Voice of the Desert”: a field guide to the strange tales, singing sand dunes, sagebrush trails, artists and aliens, authors and oddballs, ghost towns and modern legends, musicians and mystics, scorpions and saguaros, out there in the sand. Desert Oracle is your companion at a roadside diner, around a campfire, in your tent or cabin (or high-rise apartment or suburban living room) as the wind and the coyotes howl outside at night. From journal entries of long-deceased adventurers to stray railroad ad copy, and musings on everything from desert flora, rumored cryptid sightings, and other paranormal phenomena, Ken Layne's Desert Oracle collects the weird and the wonderful of the American Southwest into a single, essential volume.

Special Features: · Dive into the world of SQL and PL/SQL programming in Oracle 10g· Grasp all theoretical and practical concepts in programming· Understand the advanced features of SQL, like Analytical queries, multitable inserts, joins, Scalar subqueries, key preserving Joins, etc.· Understand the concept of Server model in software· Face OCP exams and interviews (for software professionals)· Absorb advanced features in PL/SQL, like Control structures, Collections, LOB datatype, Object types, Error handling, Triggers, Object views, Rollback segments, UNDO tablespace, Flashback queries, Sequence and Wrapper, Expression filter, in addition to Security and Audit About The Book: This book, SQL & PL/SQL Black Book, brings to you the complete, latest account of SQL and PL/SQL for Oracle. It gifts you two things-first, it upgrades your knowledge on the subject; and second the innumerable, exciting examples help you build a better skill in SQL and PL/SQL. The highlight of the book is a clear yet incisive discussion of the basic features of Oracle 9i and the latest advanced features that come with Oracle 10g. The in-depth treatment of the subject in a lucid language will give you an enjoyable learning experience as you have always had with our previous books on Oracle.This comprehensive reference will help you learn the entire spectrum of SQL-from Views to Cube and Roll Up; from Case expressions to Variances and Correlation-and PL/SQL-from Collections to Object types; from Error handling to Triggers; from Object views to Rollback segments; from UNDO tablespace to Expression filter, and many more. All this, as the book zips through the material and does not blather on or repeat points made earlier-no doubt, every aspect is worth the price of the entire book.