Bøker av Sanjay Mishra

Intermediate-Advanced user level

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task.Some of the utilities documented in this guide include:SQL*Loader, for loading dataexpdp and exp for exporting data to another databaseoradebug for use in troubleshootingloadjava and dropjava for loading and unloading Java programsPacked with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand.Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "e;pocket reference"e; books.

This text describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It covers the newest SQL*Loader features for 2001.

This title has a strong focus on practical, expert best-practices and on Oracle-specific SQL technique. It covers Oracle's vast library of built-in functions and the full range of Oracle SQl query-writing features.