Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tuning. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. Learning SQL moves you quickly through the basics and then on to some of the more commonly used advanced features. Among the topics discussed: The history of the computerized database SQL Data Statements--those used to create, manipulate, and retrieve data stored in your database; example statements include select, update, insert, and delete SQL Schema Statements--those used to create database objects, such as tables, indexes, and constraints How data sets can interact with queries The importance of subqueries Data conversion and manipulation via SQL's built-in functions How conditional logic can be used in Data StatementsBest of all, Learning SQL talks to you in a real-world manner, discussing various platform differences that you're likely to encounter and offering a series of chapter exercises that walk you through the learning process. Whenever possible, the book sticks to the features included in the ANSI SQL standards. This means you'll be able to apply what you learn to any of several different databases; the book covers MySQL, Microsoft SQL Server, and Oracle Database, but the features and syntax should apply just as well (perhaps with some tweaking) to IBM DB2, Sybase Adaptive Server, and PostgreSQL. Put the power and flexibility of SQL to work. With Learning SQL you can master this important skill and know that the SQL statements you write are indeed correct.

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL. The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10 g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers. The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization. Co-authored by the world's foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications--making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

This IBM Redbooks publication is part of a series of documents related to grid computing that IBM is presenting to the IT community to enrich it and all its players: clients, industry leaders, emerging enterprises, universities, and producers of technology. It is mainly oriented to IT architects or those who have the responsibility of analyzing the capabilities of the product used to build a grid solution. We describe the functions of grid computing and the categorizations of the components within it. IBM, ISVs, and open source products will be explained. Some of these products are not specific for grid, but they can be used in a grid computing environment. We hope that this book helps you select functions and products and shows you how grid can fit into your IT picture as new products and services for grid are introduced. Part 1 introduces the concept of grid computing and provides the terminology the readers will use in this book. Part 2 explores the functionality associated with certain products and product families. It also presents some examples of the utilization of these products in the grid computing environment. Part 3 presents grid computing product families that can be used to build a complete grid solution. These bundles, or suites, often implement most of the core grid disciplines. Part 4 gives an overview of the grid computing offerings and services that IBM provides.

XSLT is an essential tool for converting XML into other kinds of documents: HTML, PDF file, and many others. It's a critical technology for XML-based platforms such as Microsoft .NET, Sun Microsystems' Sun One, as well as for most web browsers and authoring tools. As useful as XSLT is, however, most people have a difficult time getting used to its peculiar characteristics. The ability to use advanced techniques depends on a clear and exact understanding of how XSLT templates work and interact. The XSLT 1.0 Pocket Reference from O'Reilly wants to make sure you achieve that level of understanding. With its concise approach, this handy pocket guide quickly gets you up to speed on XSLT 1.0 so you can covert XML like a seasoned pro. In addition to covering the basics of stylesheet structure, it also explains how to: use template rules create a result tree apply conditional processing transform multiple source documents employ number formatting Thanks to their convenient, quick-reference format, O'Reilly's Pocket References spare you from having to hunt through larger books for answers. They deliver just what you need to get the job done in a timely fashion. And the XSLT 1.0 Pocket Reference is no different--it's the ideal companion to have at your desk when you need an answer fast.

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.

XML, the Extensible Markup Language, is everywhere: the syntax of choice for newly designed document formats across almost all computer applications. Now used daily by developers, XML is living up to its reputation as one of the most important developments in document interchange in the history of computing. A perennial bestseller, the handy XML Pocket Reference from O'Reilly has been revised once again to give you quick access to the latest goods. In addition to its comprehensive look at XML, this third edition has been updated with new material on Namespaces and XML Schema--considered among the most important elements in current XML use--along with RELAX NG and Schematron, additional powerful tools for describing XML document structures. Like other titles in O'Reilly's Pocket Reference series, the XML Pocket Reference, 3rd Edition features a well-organized format that gets right to the point. As a result, it's already won over the allegiance of developers everywhere. If you need XML answers quick and on the fly, this compact book is most definitely the book for you.

This IBM Redbooks publication presents an overview of IBM Tivoli Storage Manager Version 5.3. It is designed as a workshop presentation guide, and therefore uses presentation slides to provide descriptions about the changes made in the new release. This format enables you to easily gain a comprehensive overview and to quickly understand the new features of Tivoli Storage Manager. This book is intended for IBM Clients, Business Partners, consultants, and IBM and Tivoli staff who are familiar with earlier releases of Tivoli Storage Manager and who want to understand what is new in Version 5.3.0, 5.3.1, and 5.3.2. We recommend that you use this book in conjunction with the ITSO workshop, the book "IBM Tivoli Storage Manager Version 5.3 Technical Guide", SG24-6638, manuals and readme files that are provided with the products. This book is not intended to replace any information contained therein.

IBM Workplace Services Express is software that makes it easy for you, your colleagues, your teams, and your entire organization to quickly collaborate and effectively work together. Designed specifically for small and medium-sized organizations with less than a thousand employees, or departmental needs in larger organizations, Workplace Services Express enables you to easily create, edit, and share documents from your own customized Workplace environment. This IBM Redbooks publication will introduce you to Workplace Services Express and its features and tell you how to deploy and customize it. Whether you are a line-of-business manager who wants to understand the business value of Workplace Services Express, an administrator who wants to install it, or an application developer who wants to customize it, this book is for you. Please note that the additional material referenced in the text is not available from IBM.

From the moment you're born, you enter the data stream-from birth certificates to medical records to what you bought on Amazon last week. As your dossier grows, so do the threats, from identity thieves to government snoops to companies who want to sell you something. Computer Privacy Annoyances shows you how to regain control of your life. You'll learn how to keep private information private, stop nosy bosses, get off that incredibly annoying mailing list, and more. Unless you know what data is available about you and how to protect it, you're a sitting duck. Computer Privacy Annoyances is your guide to a safer, saner, and more private life. Written by privacy pro Dan Tynan, and based on interviews with privacy experts from all over the globe, Computer Privacy Annoyances serves up real-world advice in bite-sized portions that will help you stop the snoops in their tracks. The book even addresses non-computing threats, from telemarketer-cum-stalkers, thieves at your mailbox, nosy folks in your HR department, cell phone eavesdroppers, and more. The key areas covered include: Privacy at Home Privacy on the Net Privacy at Work Privacy in Public Privacy and Uncle Sam Privacy in the Future Daniel Tynan has written about Internet privacy and security for nearly a decade. His work has appeared in more than 40 national publications. As executive editor at PC World, Tynan edited a special issue on Internet Privacy that won a Grand Neal Award and was a finalist for a National Magazine Award. He has won more than a dozen other honors, including nine Neals, four Maggies, and two Computer Press Association Awards.

The acquisition of Informix by IBM has provided the opportunity for Informix customers to consider new alternatives to further enrich their data management systems infrastructure. They can now more easily take advantage of available products, services, and capabilities as they grow and change. This IBM Redbooks publication focuses on strategies, techniques, capabilities, and considerations for using Informix Extended Parallel Server (XPS) and DB2 Universal Database (UDB). It provides detailed discussions and data to give a good understanding of the two products, their capabilities, and their similarities. XPS customers can choose to adopt a database strategy of coexistence or consider transitioning to DB2 UDB. The features and functionality of each DBMS are briefly described for a better understanding, in areas such as architecture, partitioning techniques, SQL considerations, configuration, indexing, data types, DML, and DDL. It also discusses products and tools to complement these database management systems. With this information, you can better decide which products satisfy your particular requirements, and better plan on how to achieve your objectives as you develop your database management system strategy. You will be better positioned to make informed decisions that can give you the best return on your DBMS investment.

This IBM Redbook introduces the IBM System z9 109 (z9-109), which offers a continuation of the IBM scalable mainframe servers. The z9-109 server is based on z/Architecture and provides extensions to the architecture. In addition to increased performance and expansion options, particular emphasis has been placed on the integration of the z9-109 into a complete system and software environment.

MS/VCR provides a fast, reliable facility with high integrity for the renaming and recataloging of data sets on target volumes after a FlashCopy or Snapshot volume copy, solving the cloned data access dilemma. This facility enables the immediate use of the data from the same system as the original copy. MS/VCR resolves catalog conflicts of like-named datasets that are created by "cloning" a volume. It also solves internal conflicts that are created when copying a volume to a different VOLSER. MS/VCR is designed to rename and catalog target volume datasets in record time. The window of time required to copy and rename a target dataset is a critical factor for many customers. This IBM Redbooks publication provides a broad understanding of the MS/VCR product and how to use it in real situations.

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the most widely used open source, enterprise-level database systems.

This IBM Redbooks publication provides advice for Business Partners or other technical people about how to plan, implement, and demonstrate IBM Tivoli Storage Manager Version 5.3 in a proof-of-concept simulated environment. This environment can be used to demonstrate the capabilities of the IBM Tivoli Storage Manager solutions using customer data, in order to gain customer acceptance for the next phase of the sell cycle to engage the Business Partner in a real proof-of-concept of IBM Tivoli Storage Manager. Please note that the additional material referenced in the text is not available from IBM.

Deploying and managing distributed systems in hundreds or thousands of branch banks and retail stores, called outlets, requires careful planning of the automation to cope with the sheer numbers of systems involved. This IBM Redbooks publication demonstrates how to architect, establish, and configure a Tivoli systems management environment that supports the central management of thousands of outlet systems based on the open United Linux platform. The main focus of this book is to provide step-by-step instructions, sample scripts, and code to install and deploy the core Tivoli products that enable the organization to: - Deploy and maintain distributed application solutions This book is intended for IT professionals with a basic understanding of the core Tivoli product set and who are responsible for deploying a Tivoli management infrastructure. Please note that the additional material referenced in the text is not available from IBM.

Jump-start your report-writing skills! Report writing has never been easier. Learn how you can easily avoid common report-writing pitfalls with SAS Guide to Report Writing: Examples, Second Edition. Updated for SAS®9, this task-oriented book guides you through the steps that you need to produce professional reports. Using a wealth of easy-to-follow examples, this time-saving book demonstrates the many different styles of reports that are available and the SAS tools used to generate them. The examples enable more experienced programmers to quickly grasp new techniques, while margin notes and additional discussions provide novice users with the details that they need for effective learning. You can save programming hours by using the SAS programs as they are or as models for developing your own reports. Whether you are a beginner or an expert, this must-have guide will strengthen your report-writing expertise and give you the tools that you need to enhance the power of your reports!

In development scenarios where things can't be run in a debugger, or when you run the risk of masking the problem, logs are the greatest source of information about running a program. Pro Apache Log4j, Second Edition provides best practices guidelines and comprehensive coverage of the most recent release. Step by step, the book explains core concepts, from basic to advanced. Code samples are in Java and include guidelines for different application-specific needs. You’ll also learn how to extend the API to write custom components and best practices for using the feature-rich log4j API. This book concludes with enterprise Java applications using log4j with JSP and J2EE.

This IBM Redbooks publication is an easy-to-follow guide that describes how to implement IBM Tivoli Storage Manager Version 5.3 products in highly available clustered environments. The book is intended for those who want to plan, install, test, and manage the IBM Tivoli Storage Manager Version 5.3 in various environments by providing best practices and showing how to develop scripts for clustered environments. The book covers the following environments: IBM AIX HACMP, IBM Tivoli System Automation for Multiplatforms on Linux and AIX, MicrosoftCluster Server on Windows 2000 and Windows 2003, VERITAS Storage Foundation HA on AIX, and Windows Server 2003 Enterprise Edition. Please note that the additional material referenced in the text is not available from IBM.

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from www.mrexcel.com, and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.