"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.
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.
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.
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.
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.
THE MORE YOU KNOW ABOUT THE FUTURE, THE MORE THERE MAY BE TO FEAR. Tara Sheridan is the best criminal profiler around—and the most unconventional. Trained as a forensic psychologist, Tara also specializes in Tarot card reading. But she doesn’t need her divination skills to realize that the new assignment from her friend and sometime lover, Agent Harry Li, is a dangerous proposition in every way. Former Cold War operatives, all linked to a top-secret operation tracking the disposal of nuclear weapons in Russia, are disappearing. There are no bodies, and no clues to their whereabouts. Harry suspects a conspiracy to sell arms to the highest bidder. The cards—and Tara’s increasingly ominous dreams—suggest something darker. Even as Tara sorts through her feelings for Harry and her fractured relationship with the mysterious order known as Delphi’s Daughters, a killer is growing more ruthless by the day. And a nightmare that began decades ago in Chernobyl will reach a terrifying endgame that not even Tara could have foreseen. . . .
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.
Presents an ideal mix of theory and practice, which allows the reader to understand the principle behind the application.; Coverage of performance tuning of datawarehouses offers readers the principles and tools they need to handle large reporting databases.; Material can also be used in a non-Oracle environment; Highly experienced author.