Wow! eBook – Blog

Book Description

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.

This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:

• Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)
• Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle’s self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)
• Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)
• Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider

The latest Oracle Database 11g features: query result set caching Download Now »

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 »