Author: Jonathan Gennick Publisher: "O'Reilly Media, Inc." ISBN: 0596552491 Category : Computers Languages : en Pages : 67
Book Description
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.
Author: Dan Pilone Publisher: "O'Reilly Media, Inc." ISBN: 9780596004972 Category : Computers Languages : en Pages : 100
Book Description
The Unified Modeling Language (UML) is one of the most important languages for anyone in the software industry to know. The UML is a visual language enabling architects, designers, and developers to communicate about design. Seemingly simple on the surface, the UML is a rich and expressive language, with many visual syntactical elements. It's next to impossible to memorize all aspects of the UML. Just as a writer might require a dictionary to work with the spoken word, so too do UML practitioners require a dictionary of sorts. In this book, you'll find information on UML usage, and also on the symbols, line-endings, and syntax used for the following diagram types: Class diagrams Component diagrams Behavioral diagrams Sequence diagrams Statechart diagrams Object diagrams Deployment diagrams Use case diagrams Collaboration diagrams Activity diagrams Let this book be your UML dictionary. It's clear, concise, and small. Keep this book at hand, and never again be stymied by an unfamiliar UML symbol, a line-ending you don't recognize, or the use of an unfamiliar diagram type. O'Reilly's Pocket References have become a favorite among programmers 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. When you need to get to a solution quickly, the new UML Pocket Reference is the book you'll want to have.
Author: Arnold Robbins Publisher: "O'Reilly Media, Inc." ISBN: 0596552025 Category : Computers Languages : en Pages : 53
Book Description
For people who create and modify text files, sed and awk are power tools for editing. sed, awk, and regular expressions allow programmers and system administrators to automate editing tasks that need to be performed on one or more files, to simplify the task of performing the same edits on multiple files, and to write conversion programs.The sed & awk Pocket Reference is a companion volume to sed & awk, Second Edition, Unix in a Nutshell, Third Edition, and Effective awk Programming, Third Edition. This new edition has expanded coverage of gawk (GNU awk), and includes sections on: 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 This small book is a handy reference guide to the information presented in the larger volumes. It presents a concise summary of regular expressions and pattern matching, and summaries of sed and awk.Arnold Robbins, an Atlanta native now happily living in Israel, is a professional programmer and technical author and coauthor of various O'Reilly Unix titles. He has been working with Unix systems since 1980, and currently maintains gawk and its documentation.
Author: Joe Celko Publisher: Elsevier ISBN: 0080460046 Category : Computers Languages : en Pages : 839
Book Description
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics. - Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. - Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment. - Offers tips for working around system deficiencies. - Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.
Author: Johan Vromans Publisher: "O'Reilly Media, Inc." ISBN: 1449378846 Category : Computers Languages : en Pages : 99
Book Description
The Perl Pocket Reference is an invaluable reference for those who find themselves frequently searching for a quick answer to a question or reminder of a syntax rule. This handy, well-organized quick reference condenses stacks of Perl documentation down to the most essential at-your-fingertips facts. For ease-of-use, convenience, and price, this little reference is the first place Perl programmers look when they need an answer quickly.The Perl Pocket Referenc provides a complete overview of the Perl programming language, all packed into a convenient, carry-around booklet. It is updated for Perl 5.8, and covers a summary of Perl syntax rules, a complete list of operators, built-in functions, and standard library modules, all with brief descriptions. Also included are the newest Perl features, such as enhanced regular expressions, multithreading, the Perl compiler, and Unicode support.The Perl Pocket Reference, 4th Edition, is the perfect companion to the authoritative books on Perl published by O'Reilly & Associates: Programming Perl, Learning Perl, and the Perl Cookbook. This pocket reference will never make it to the bookshelf--dog-eared and well worn, it will remain within arms reach of the keyboard or tucked in a back pocket, where it will be referred to on a daily basis.
Author: Allison Randal Publisher: "O'Reilly Media, Inc." ISBN: 9780596007379 Category : Computers Languages : en Pages : 302
Book Description
This look at Perl 6 uncovers developments in Parrot - the interpreter engine that will execute code written in the new Perl 6 language and the most revolutionary change in the language itself - Apocalypse 12 on objects.
Author: Joe Celko Publisher: Elsevier ISBN: 0080495931 Category : Computers Languages : en Pages : 205
Book Description
Joe Celko's Analytics and OLAP in SQL is the first book that teaches what SQL programmers need in order to successfully make the transition from On-Line Transaction Processing (OLTP) systems into the world of On-Line Analytical Processing (OLAP). This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face — if they want to grow. It contains expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. It offers real-world insights and lots of practical examples. It covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software. This book is ideal for experienced SQL programmers who have worked with OLTP systems who need to learn techniques—and even some tricks—that they can use in an OLAP situation. - Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums - First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of data warehouse data and OLAP - Offers real-world insights and lots of practical examples - Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software
Author: Jonathan Gennick Publisher: "O'Reilly Media, Inc." ISBN: 0596552610 Category : Computers Languages : en Pages : 584
Book Description
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQLPlus environment and much more It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.
Proudly powered by WordPress |
Theme: Rits Blog by Crimson Themes.
Author: Tony Stubblebine
Author: Jonathan Gennick
Author: Dan Pilone
Author: Arnold Robbins
Author: Donald Lewine
Author: Joe Celko
Author: Johan Vromans
Author: Allison Randal
Author: Joe Celko
Author: Jonathan Gennick