Follow the authors

• An overview of sed and awk?s command line syntax
• Alphabetical summaries of commands, including nawk and gawk
• Profiling with pgawk
• Coprocesses and sockets with gawk
• Internationalization with gawk
• A listing of resources for sed and awk users

Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data.

This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.

O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

Few .NET developers have the luxury of unlimited code testing once their application is complete, and rushing through the testing process is both problematic and stressful. The open source NUnit framework provides an excellent and efficient way to test and improve .NET code as it's written, saving hundreds of QA hours and headaches.

NUnit is one of the most mature and widely-used .NET open source projects even Microsoft uses it internally. NUnit is a unit-testing framework for all .Net languages. Written entirely in C#, NUnit takes advantage of many .NET language features, such as custom attributes and other reflection related capabilities. It automates unit testing and reduces the effort required to frequently test code while developing it. NUint is invaluable for .NET developers in test-driven development under agile methodologies such as Extreme Programming (XP) as well as for developers who use for unit testing for software quality assurance. Unfortunately, some of those valuable hours saved by using NUnit can be wasted trying to master this powerful but under-documented framework

Proof that good things come in small packages, the NUnit Pocket Reference is a complete reference to NUnit, filling in the blanks left by the existing documentation and online discussion. It offers developers everything they need to know to install, configure, and use NUnit; the NUnit user interface; and a reference to the NUnit framework classes in a slim but well-organized package. This handy little book even offers practical, real world NUnit examples. And with the NUnit Pocket Reference, IT managers will know to expect when they implement unit testing in their projects. It is the only book you'll need on this popular and practical new open source framework.

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 data
• expdp and exp for exporting data to another database
• oradebug for use in troubleshooting
• loadjava and dropjava for loading and unloading Java programs

• Differentiate between SQL and SQL*Plus
• Interact with SQL*Plus from both the command line and the web browser
• Select, insert, update, and delete data
• Format both text and HTML reports with SQL*Plus
• Specify SQL*Plus commands and format elements
• Tune SQL queries

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.

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.

But to take full advantage of a digital camera, you need to be an experienced photographer and an expert at digital photography too. With more than 15 years of experience as a photojournalist, author Derrick Story brings you Digital Photography Pocket Guide, 3rd Edition. For everyone who owns or will own a digital camera (and that pretty much means everyone!), this is the perfect on-the-go guide for taking top-notch digital photos.

In this third edition of the bestselling pocket guide, Story expands on the basic photography techniques that he introduced in earlier editions, including an explanation of each camera component and what it does, tips for choosing just the right settings for your needs, and much more. This indispensable guide covers everything from how to shoot sports action, close ups, and night shots, to dealing with image resolution, archiving, and memory cards.

Affordable and portable, Digital Photography Pocket Guide, 3rd Edition offers full-color photographs, screen shots, and line art illustrating all the topics in the guide's three main sections ("Digital Camera Components," "Standard Camera Functions," and "How Do I?"). Contents are labeled A to Z for quick reference. There's also a comprehensive table of contents and index so you'll waste no time flipping to the specific information you need--whether you want to transfer images, make a QuickTime movie, or just figure out what purpose that mystery setting on your camera serves. There's even a section of easy-to-read reference tables for quick look-up of white balance settings, exposure compensation, camera mode explanations, and plenty more.

Globe-trotting travelers have long resorted to handy, pocket-size dictionaries as an aid to communicating across the language barrier. Dan Pilone's UML 2.0 Pocket Reference is just such an aid for on-the-go developers who need to converse in the Unified Modeling Language (UML). Use this book to decipher the many UML diagrams you'll encounter on the path to delivering a modern software system.

Updated to cover the very latest in UML, you'll find coverage of the following UML 2.0 diagram types:

• Class diagrams
• Component diagrams*
• Sequence diagrams*
• Communication diagrams*
• Timing diagrams*
• Interaction Overview diagrams*
• Package diagrams*
• Deployment diagrams*
• Use case diagrams
• Composite structure diagrams*
• Activity diagrams*
• Statechart diagrams*

Also new in this edition is coverage of UML's Object Constraint Language (OCL). Using OCL, you can specify more narrowly the functionality described in a given diagram by recording limits that are the result of business rules and other factors.

The UML 2.0 Pocket Reference travels well to meetings and fits nicely into your laptop bag. It's near impossible to memorize all aspects of UML, and with this book along, you won't have to.

SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.

Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:

• Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE))
• Microsoft SQL Server 2005
• MySQL 5
• IBM DB2 8.2
• PostreSQL 8.1 database

After years of using spacer GIFs, layers of nested tables, and other improvised solutions for building your web sites, getting used to the more stringent "standards-compliant" design that is de rigueur among professionals today can be intimidating.

With standards-driven design, keeping style separate from content is not just a possibility but a reality. You no longer use HTML and XHTML as design tools, but strictly as ways to define the meaning and structure of web content. And Cascading Style Sheets (CSS) are no longer just something interesting to tinker with, but a reliable method for handling all matters of presentation, from fonts and colors to page layout. When you follow the standards, both the site's design and underlying code are much cleaner. But how do you keep all those HTML and XHTML tags and CSS values straight?

Jennifer Niederst-Robbins, the author of our definitive guide on standards-compliant design, Web Design in a Nutshell, offers you the perfect little guide when you need answers immediately: HTML and XHTML Pocket Reference. This revised and updated new edition takes the top 20% of vital reference information from her Nutshell book, augments it judiciously, cross-references everything, and organizes it according to the most common needs of web developers. The result is a handy book that offers the bare essentials on web standards in a small, concise format that you can use carry anywhere for quick reference. This guide will literally fit into your back pocket.

Inside HTML and XHTML Pocket Reference, you'll find instantly accessible alphabetical listings of every element and attribute in the HTML 4.01 and XHTML 1.0 Recommendations. This is an indispensable reference for any serious web designer, author, or programmer who needs a fast on-the-job resource when working with established web standards.

• How to configure MySQL, such as setting the root password
• MySQL data types, including numerics, strings, dates, and complex types
• SQL syntax, commands, data types, operators, and functions
• Arithmetic, comparison and logical operators
• Aggregate and general functions
• Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers