Oracle Regular Expressions Pocket Reference

Tutorial & Quick Reference

Author: Jonathan Gennick,Peter Linsley

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596552497

Category: Computers

Page: 66

View: 3997

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.

Regular Expression Pocket Reference

Regular Expressions for Perl, Ruby, PHP, Python, C, Java and .NET

Author: Tony Stubblebine

Publisher: "O'Reilly Media, Inc."

ISBN: 0596514271

Category: Computers

Page: 117

View: 6130

A guide to the syntax and semantics of regular expressions for Perl 5.8, Ruby, Java, PHP, C#, .NET, Python, JavaScript, and PCRE.

SQL Pocket Guide

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596554538

Category: Computers

Page: 192

View: 1386

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

Oracle PL/SQL Language Pocket Reference

Author: Steven Feuerstein,Bill Pribyl,Chip Dawes

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596551612

Category: Computers

Page: 180

View: 5896

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

Oracle SQL*Loader

The Definitive Guide

Author: Jonathan Gennick,Sanjay Mishra

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565929487

Category: Computers

Page: 251

View: 1666

A complete guide to SQL*Loader, a utility used to move data from external files into an Oracle database, offers step-by-step instruction in the various applications of SQL*Loader, providing a task-oriented approach that covers the latest Oracle 8 and Oracle 8i features. Original. (Beginner/Intermediate)

Mastering Regular Expressions

Understand Your Data and Be More Productive

Author: Jeffrey E.F. Friedl

Publisher: "O'Reilly Media, Inc."

ISBN: 1449332536

Category: Computers

Page: 544

View: 5086

Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Perl, Python, Ruby, Java, VB.NET and C# (and any language using the .NET Framework), PHP, and MySQL. If you don't use regular expressions yet, you will discover in this book a whole new world of mastery over your data. If you already use them, you'll appreciate this book's unprecedented detail and breadth of coverage. If you think you know all you need to know about regularexpressions, this book is a stunning eye-opener. As this book shows, a command of regular expressions is an invaluable skill. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated. Regular expressions can save you time and aggravation. They can be used to craft elegant solutions to a wide range of problems. Once you've mastered regular expressions, they'll become an invaluable part of your toolkit. You will wonder how you ever got by without them. Yet despite their wide availability, flexibility, and unparalleled power, regular expressions are frequently underutilized. Yet what is power in the hands of an expert can be fraught with peril for the unwary. Mastering Regular Expressions will help you navigate the minefield to becoming an expert and help you optimize your use of regular expressions. Mastering Regular Expressions, Third Edition, now includes a full chapter devoted to PHP and its powerful and expressive suite of regular expression functions, in addition to enhanced PHP coverage in the central "core" chapters. Furthermore, this edition has been updated throughout to reflect advances in other languages, including expanded in-depth coverage of Sun's java.util.regex package, which has emerged as the standard Java regex implementation.Topics include: A comparison of features among different versions of many languages and tools How the regular expression engine works Optimization (major savings available here!) Matching just what you want, but not what you don't want Sections and chapters on individual languages Written in the lucid, entertaining tone that makes a complex, dry topic become crystal-clear to programmers, and sprinkled with solutions to complex real-world problems, Mastering Regular Expressions, Third Edition offers a wealth information that you can put to immediateuse. Reviews of this new edition and the second edition: "There isn't a better (or more useful) book available on regular expressions." --Zak Greant, Managing Director, eZ Systems "A real tour-de-force of a book which not only covers the mechanics of regexes in extraordinary detail but also talks about efficiency and the use of regexes in Perl, Java, and .NET...If you use regular expressions as part of your professional work (even if you already have a good book on whatever language you're programming in) I would strongly recommend this book to you." --Dr. Chris Brown, Linux Format "The author does an outstanding job leading the reader from regexnovice to master. The book is extremely easy to read and chock full ofuseful and relevant examples...Regular expressions are valuable toolsthat every developer should have in their toolbox. Mastering RegularExpressions is the definitive guide to the subject, and an outstandingresource that belongs on every programmer's bookshelf. Ten out of TenHorseshoes." --Jason Menard, Java Ranch

Regular Expressions Cookbook

Detailed Solutions in Eight Programming Languages

Author: Jan Goyvaerts,Steven Levithan

Publisher: "O'Reilly Media, Inc."

ISBN: 1449327486

Category: Computers

Page: 612

View: 9482

Take the guesswork out of using regular expressions. With more than 140 practical recipes, this cookbook provides everything you need to solve a wide range of real-world problems. Novices will learn basic skills and tools, and programmers and experienced users will find a wealth of detail. Each recipe provides samples you can use right away. This revised edition covers the regular expression flavors used by C#, Java, JavaScript, Perl, PHP, Python, Ruby, and VB.NET. You’ll learn powerful new tricks, avoid flavor-specific gotchas, and save valuable time with this huge library of practical solutions. Learn regular expressions basics through a detailed tutorial Use code listings to implement regular expressions with your language of choice Understand how regular expressions differ from language to language Handle common user input with recipes for validation and formatting Find and manipulate words, special characters, and lines of text Detect integers, floating-point numbers, and other numerical formats Parse source code and process log files Use regular expressions in URLs, paths, and IP addresses Manipulate HTML, XML, and data exchange formats Discover little-known regular expression tricks and techniques

Oracle SQL Recipes

A Problem-Solution Approach

Author: Grant Allen,Bob Bryla,Darl Kuhn,Chris Allen

Publisher: Apress

ISBN: 1430225106

Category: Computers

Page: 576

View: 1762

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you from that drudgery by providing tested and working examples of SQL used to solve common problems faced by developers and database administrators on a daily basis. When you're under pressure to get results fast, Oracle SQL Recipes is there at your side. Example-based, providing quality solutions to everyday problems Respects your time by putting solutions first and keeping discussions short Solves the most commonly encountered SQL problems

Mastering Oracle SQL

Putting Oracle SQL to Work

Author: Sanjay Mishra,Alan Beaulieu

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596552473

Category: Computers

Page: 496

View: 3143

The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.

grep Pocket Reference

A Quick Pocket Reference for a Utility Every Unix User Needs

Author: John Bambenek,Agnieszka Klus

Publisher: "O'Reilly Media, Inc."

ISBN: 059655446X

Category: Computers

Page: 86

View: 4184

grep Pocket Reference is the first guide devoted to grep, the powerful Unix content-location utility. This handy book is ideal for system administrators, security professionals, developers, and others who want to learn more about grep and take new approaches with it -- for everything from mail filtering and system log management to malware analysis. With grep Pocket Reference, you will: Learn methods for filtering large files for specific content Acquire information not included in the current grep documentation Get several tricks for using variants such as egrep Keep key information about grep right at your fingertips Find the answers you need about grep quickly and easily. If you're familiar with this utility, grep Pocket Reference will help you refresh your basic knowledge, understand rare situations, and work more efficiently. If you're new to grep, this book is the best way to get started.

Oracle SQL*Plus: The Definitive Guide

The Definitive Guide

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596552619

Category: Computers

Page: 584

View: 1220

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.

Introducing Regular Expressions

Unraveling Regular Expressions, Step-by-Step

Author: Michael Fitzgerald

Publisher: "O'Reilly Media, Inc."

ISBN: 1449338895

Category: Computers

Page: 154

View: 3664

If you’re a programmer new to regular expressions, this easy-to-follow guide is a great place to start. You’ll learn the fundamentals step-by-step with the help of numerous examples, discovering first-hand how to match, extract, and transform text by matching specific words, characters, and patterns. Regular expressions are an essential part of a programmer’s toolkit, available in various Unix utlilities as well as programming languages such as Perl, Java, JavaScript, and C#. When you’ve finished this book, you’ll be familiar with the most commonly used syntax in regular expressions, and you’ll understand how using them will save you considerable time. Discover what regular expressions are and how they work Learn many of the differences between regular expressions used with command-line tools and in various programming languages Apply simple methods for finding patterns in text, including digits, letters, Unicode characters, and string literals Learn how to use zero-width assertions and lookarounds Work with groups, backreferences, character classes, and quantifiers Use regular expressions to mark up plain text with HTML5

Oracle SQL*Plus Pocket Reference

Author: Jonathan Gennick

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008856

Category: Computers

Page: 146

View: 8863

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10g to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN. With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQL*Plus: The Definitive Guide. Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.

JavaScript

The Definitive Guide

Author: David Flanagan

Publisher: "O'Reilly Media, Inc."

ISBN: 0596805527

Category: Computers

Page: 1078

View: 3615

A revised and updated edition offers comprehensive coverage of ECMAScript 5 (the new JavaScript language standard) and also the new APIs introduced in HTML5, with chapters on functions and classes completely rewritten and updated to match current best practices and a new chapter on language extensions and subsets. Original.

Regular Expression Recipes

A Problem-Solution Approach

Author: Nathan A. Good

Publisher: Apress

ISBN: 159059441X

Category: Computers

Page: 289

View: 2266

Regular expressions are an essential part of programming, but they sure are hard to come to grips with, aren’t they? Fortunately, we have the answer for you! Regular Expression Recipes provides you with all the open-source regular expressions you’ll ever need, and explains how to use each one. This way, you can learn by example, rather than muddling through countless pages of explanatory syntax. Author Nathan A. Good includes syntax references only when necessary. Languages covered include Perl, PHP, grep, vim, Python, and shell. Web and applications developers, and system administrators will find the examples both accurate and relevant. And this book acts as a useful reference to keep handy for those moments when an answer is needed fast. Table of Contents Words and Text URLs and Paths CSV and Tab-Delimited Files Formatting and Validating HTML and XML Coding and Using Commands

Java Regular Expressions

Taming the java.util.regex Engine

Author: Mehran Habibi

Publisher: Apress

ISBN: 1430207094

Category: Computers

Page: 280

View: 4251

Expert author Habibi offers a look at what regular expressions are and how to use the Java library to process them. His book uses plenty of examples to show typical and atypical uses of the library, thus becoming a powerful learning tool. For instance, comprehensive examples for each and every regex method and class are given, along with advice on their appropriate use and performance considerations.

Sams Teach Yourself PL/SQL in 21 Days

Author: Jonathan Gennick,Tom Luers

Publisher: Sams Publishing

ISBN: 9780672317989

Category: Computers

Page: 692

View: 6667

Presented in an easy-to-learn, tutorial style, this "teach yourself" guide has been revised to include new features of Oracle 8i. New topics include: extended dynamic SQL within PL/SQL; use of invoker's rights; interfacing; and more. Web site includes author examples and source code.

HTTP Pocket Reference

Hypertext Transfer Protocol

Author: Clinton Wong

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449379605

Category: Computers

Page: 82

View: 990

The HyperText Transfer Protocol, or HTTP, is the backbone of the World Wide Web. HTTP is the language that each web browser (or other web client) uses to communicate with servers around the world. All web programmers, administrators, and application developers need to be familiar with HTTP in order to work effectively.The HTTP Pocket Reference not only provides a solid conceptual foundation of HTTP, it also serves as a quick reference to each of the headers and status codes that comprise an HTTP transaction. The book starts with a tutorial of HTTP, but then explains the client request and server responses in more detail, and gives a thorough technical explanation of more advanced features of HTTP (such as persistent connections and caching).Most people use the Web every day without knowing anything about HTTP, but for those who need to get "beyond the browser," this book is the place to start.

Oracle PL/SQL Best Practices

Optimizing Oracle Code

Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449378769

Category: Computers

Page: 208

View: 9883

In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"--rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors--and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code: How should I format my code? What naming conventions, if any, should I use? How can I write my packages so they can be more easily maintained? What is the most efficient way to query information from the database? How can I get all the developers on my team to handle errors the same way? The book contains 120 best practices, divided by topic area. It's full of advice on the program development process, coding style, writing SQL in PL/SQL, data structures, control structures, exception handling, program and package construction, and built-in packages. It also contains a handy, pull-out quick reference card. As a helpful supplement to the text, code examples demonstrating each of the best practices are available on the O'Reilly web site.Oracle PL/SQL Best Practices is intended as a companion to O'Reilly's larger Oracle PL/SQL books. It's a compact, readable reference that you'll turn to again and again--a book that no serious developer can afford to be without.

Java Pocket Guide

Instant Help for Java Programmers

Author: Robert Liguori,Patricia Liguori

Publisher: "O'Reilly Media, Inc."

ISBN: 1491938641

Category: Computers

Page: 290

View: 6984

Any time you need quick answers for developing or debugging Java programs, this pocket guide is the ideal reference to standard features of the Java programming language and its platform. You’ll find helpful programming examples, tables, figures, and lists fast—including Java 9 features such as modular source code and the new JShell interactive command-line REPL. It’s a handy companion, whether you’re in the office, in the lab, or on the road. This book also provides material to help you prepare for the Oracle Certified Associate Java Programmer exam. Quickly find Java language details, such as naming conventions, types, statements and blocks, and object-oriented programming Get details on the Java SE platform, including development basics, memory management, concurrency, and generics Use new features in Java 9, including modular source code and JShell Browse through information on basic input/output, NIO 2.0, the Java collections framework, and the Java Scripting API Get supplemental references to fluent APIs, third-party tools, and basics of the Unified Modeling Language (UML)