Wow! eBook – Blog

Book Description

PL/SQL, Oracle’s programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control–all closely integrated with the Oracle database server.

Knowing where to start with Oracle’s procedural language is not always obvious to a newcomer, especially considering the language’s feature set and the sheer size of the official documentation (not to mention Oracle’s ever-increasing number of pre-built PL/SQL programs). But Learning Oracle PL/SQL offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials.

Topics include:

• PL/SQL–what is it, and why use it? Why use PL/SQL instead of Java?
• Syntax and examples of all core language constructs
• Creating, using, and reusing stored procedures, functions, and packages
• Building web-based applications using PL/SQL features available “out of the box” (such as PL/SQL Server Pages)
• Securing PL/SQL programs against attack
• Benefits of third-party developer tools and integrated development environments Download Now »

Book Description

However excellent they are, most computer books are inherently passive–readers simply take in text without having any opportunity to react to it. The Oracle PL/SQL Developer’s Workbook is a different kind of animal! It’s designed to engage you actively, to get you solving programming problems immediately, and to help you apply what you’ve learned about PL/SQL–and in the process deepen your knowledge of the language. By tackling the exercises in this workbook, you’ll find yourself moving more rapidly along the learning curve to join the growing ranks of PL/SQL experts.

The Oracle PL/SQL Developer’s Workbook is a companion to Steven Feuerstein’s bestselling Oracle PL/SQL Programming and his other PL/SQL books from O’Reilly. It contains a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer–both with PL/SQL and with other languages. Exercises are provided at three levels: beginner, intermediate, and expert. The workbook exercises cover all the major features of PL/SQL, including those new to Oracle8i (e.g., Java and web features, autonomous transactions, and bulk binds).

You’ll find chapters on:

• Basic language elements–variables, naming, loops, conditional and sequential control, exception handling, and records.
• Data structures–index-by tables, nested tables, variables arrays (VARRAYs), and object technology.
• Database interaction–cursors, DML and transaction management Download Now »

Book Description

SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It’s optimized for loading large volumes of data, and is flexible enough to handle virtually any input format.

Almost every Oracle user has to use SQLLoader at one time or another, and DBAs are frequently called upon to load data for the users in their organization. Despite SQLLoader’s wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQLLoader: The Definitive Guide has everything you need to know to put SQLLoader to its best use: an introduction to SQLLoader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQLLoader tasks you’d want to perform–and maybe some you didn’t realize you COULD perform.

You’ll learn how to construct the necessary control files and load from different types of files containing different types of data (e.g., fixed-width data, delimited data, and data of various datatypes). You’ll also learn how to validate data, load it selectively, transform it as it is loaded, and recover after failure. This book explains how to optimize SQLLoader performance by adjusting the transaction size and using the new direct path option. It also covers the newest SQLLoader features–the loading of large object (LOB) columns and the new object types (nested tables, varying arrays, and object tables).

Oracle SQLLoader: The Definitive Guide is an indispensable resource Download Now »

Book Description

For programmers, analysts, and database administrators, SQL in a Nutshell is the essential reference for the SQL language used in today’s most popular database products. This new edition clearly documents every SQL command according to the latest ANSI standard, and details how those commands are implemented in Microsoft SQL Server 2008, Oracle 11g, and the MySQL 5.1 and PostgreSQL 8.3 open source database products. You’ll also get a concise overview of the Relational Database Management System (RDBMS) model, and a clear-cut explanation of foundational RDBMS concepts — all packed into a succinct, comprehensive, and easy-to-use format. This book provides:

• Background on the Relational Database Model, including current and previous SQL standards
• Fundamental concepts necessary for understanding relational databases and SQL commands
• An alphabetical command reference to SQL statements, according to the SQL2003 ANSI standard
• The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server
• An alphabetical reference of the ANSI SQL2003 functions, as well as the vendor implementations
• Platform-specific functions unique to each implementation

Beginning where vendor documentation ends, SQL in a Nutshell distills the experiences of professional database administrators and developers who have used SQL variants to support complex enterprise applications. Whether SQL is new to you, or you’ve been using SQL since its earliest days, you’ll get lots of new tips and techniques in this book.

Download Now »

Book Description

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 with 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 tasks: monitoring the Oracle alert log and databases Download Now »

Book Description

The Oracle database is one of the most popular in the world, and for good reason. It’s compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however–it’s a highly complex database that’s becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs).

Fortunately, the Oracle DBA Pocket Guide from O’Reilly is on the case. This handy reference is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you’ll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips.

Moreover, the Oracle DBA Pocket Guide covers Oracle Database 9i, as well as its latest release, Oracle Database 10g. The first database designed for enterprising grid computing, Oracle Database 10g significantly reduces the cost of managing the IT environment with a simplified install, reduced configuration and management requirements, and automatic performance diagnosis and SQL tuning.

The latest in O’Reilly’s line of bestselling Oracle titles, this book is an invaluable companion for any database administrator–new or experienced–interested in reviewing core Oracle concepts at a glance.

Table of Contents Download Now »