Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities. The goal of Oracle in a Nutshell is to bring order to the chaos of Oracle informatio n -- to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security admini strators need as they manage Oracle databases and write code for these databases.

From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!

Using a series of labs with examples and exercises, this guide introduces how to write programs in PL/SQL with discussion of syntax and structured programming, iterative control, scoping and anchored databases, cursors, triggers, security, tables, and packaging and parameter passing techniques. Integrated book-and-Web learning solution teaches all of the Oracle PL/SQL skills you need, through hands-on, real-world labs, exercises, projects, and the Web-based training site.

From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators.

New edition which adds chapters describing PL/SQL in terms of object features and tuning, and includes expanded discussions of debugging and tracing execution. Twenty-six chapters discuss topics including programming, language elements, built-in functions, modular code, and new PL/SQL8 features. The included disk contains the Oracle PL/SQL programming utilities guide which offers approximately 100 files of source code and documentation. Oracle PL/SQL Programming has been an indispensable refere nce for both novice and experienced PL/SQL developers since its first edition. Now in its third edition, the book has been thoroughly revised and updated to include the latest Oracle releases (Oracle8i and Oracle9i) the "Internet databases" that communicate with other technologies, such as Java, to run powerful e-commerce applications.

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal. You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities. The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate wi th Oracle databases. Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason. The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tas ks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more.

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner.

This authorized guide from Oracle Press explains how to implement the Oracle9i Server on Windows NT/2000. You'll get details on operating system fundamentals, installation, and configuration, plus intermediate and advanced topics such as architecture, migration, clustering, parallel server

Maximize all of the enhanced capabilities of Oracle9i using the precise information presented in this convenient resource, officially authorized by Oracle Corporation. Inside, you'll find full details on all the new Oracle9i features, including database administration and management improvements, architecture changes, performance enhancements, security advancements, and high-availability innovations.

More and more, technology professionals are relying on the Web, online help, and other online information sources to solve their tough problems. Now O'Reilly's Linux Web Server CD Bookshelf gives you the same convenient online access to your favorite O'Reilly books - from your CD-ROM drive. The Linux Web Server CD Bookshelf delivers the information power of six complete O'Reilly Animal Guides covering the best of the open source web platform. We've included unabridged versions of Running Linux, 3rd Edition; Linux in a Nutshell, 3rd Edition; Apache: The Definitive Guide, 2nd Edition; MySQL & mSQL; Programming the Perl DBI; and CGI Programming with Perl, 2nd Edition. As a bonus, you also get the new paperback version of Linux in a Nutshell. This confluence of open source technologies represents the platform of choice for developing and deploying high performance web applications. Apache, MySQL, and Perl/Python/PHP are the tools that make Linux a great applications development platfor m, especially for robust web applications that run on Linux servers. Never has it been easier to find what you need to know about Linux web servers online. Formatted in HTML, The Linux Web Server CD Bookshelf can be accessed with any web browser. The books - all 3276 pages of O'Reilly reference and tutorials - are fully searchable and cross-referenced, so you can search the individual index for each book or the master index for the entire collection. With the CD Bookshelf, you have a complete li brary of technical books that you can easily carry with you anywhere you need it.

2001-2007 Oracle-Books.com