In this text, John Garmany leverages his ability to explain complex issues in plain English into a one-of-a-kind book for SQL and SQL*Plus beginners. This book is intended for anyone who needs to extract Oracle data and format reports. John reveals even more secrets for quickly and easily producing stunning reports from Oracle. Unknown to most Oracle professionals, special SQL extraction techniques and SQL*Plus commands can be used to quickly create complex reports, without buying expensive third-party reporting tools. Best of all, John Garmany's exciting second edition shares more working samples in his online code depot than before. Your time savings from a single script is worth the price of this great book. Easy Oracle SQL is your introduction to using SQL and SQL*Plus with an Oracle database. Whether you are just learning SQL or just need a handy reference, this book will provide you with proven methods to building queries and reports using SQL. Each concept is explained in detail with multiple examples and exercises at the end of each section. Also included is a section detailing how to effectively use SQL*Plus to not only create and run queries but also to create quality reports and scripts. This book will have you up and using SQL quickly and efficiently.

Oracle Goldengate 11g Complete Cookbook follows the Cookbook style. Each recipe provides step by step instructions with various examples and scripts. This book provides the necessary information to successfully complete most of the possible administration tasks. Oracle Goldengate 11g Complete Cookbook is aimed at Database Administrators, Architects, and Middleware Administrators who are keen to know more about Oracle Goldengate. Whether you are handling Goldengate environments on a day-to-day basis, or using it just for migration, this book provides the necessary information required to successfully complete your administration tasks. The reader is expected to have some knowledge of Oracle databases.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Implement a Centralized Cloud Storage Infrastructure with Oracle Automatic Storage Management Build and manage a scalable, highly available cloud storage solution. Filled with detailed examples and best practices, this Oracle Press guide explains how to set up a complete cloud-based storage system using Oracle Automatic Storage Management. Find out how to prepare hardware, build disk groups, efficiently allocate storage space, and handle security. Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management shows how to monitor your system, maximize throughput, and ensure consistency across servers and clusters. Set up and configure Oracle Automatic Storage Management Discover and manage disks and establish disk groups Create, clone, and administer Oracle databases Consolidate resources with Oracle Private Database Cloud Control access, encrypt files, and assign user privileges Integrate replication, file tagging, and automatic failover Employ pre-engineered private cloud database consolidation tools Check for data consistency and resync failed disks Code examples in the book are available for download

Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle's PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web and Internet programming. Updated through Oracle9i, includes sample programs downloadable from examples.oreilly.com/learnoracle.

Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c. Whether you're a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of: Fundamental language elements, such as block structure, datatypes, and declarations Statements for program control, cursor management, and exception handling Records, procedures, functions, triggers, and packages Execution of PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more productive; using Toad, you'll find that program changes that once took hours can now be completed in minutes. Toad allows developers to browse their database tables, procedures, and object types; use code templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics.

Updated for Toad Versions 8.0 and 8.5, this pocket book is packed with quick-reference material: Toad feature and menu summaries, shortcut keys, suggested changes to Toad defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic Toad components: the SQL Editor, Procedure Editor, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization.

Whether you're a new or experienced Toad user, you'll find this quick reference an indispensable companion to the product and its online help files.

The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference.

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle9i, Oracle8i, and earlier databases. You don't need to be a Perl expert to reap the rewards of reading Perl for Oracle DBAs. The book explains what you need to know about Perl, profiles the best Perl open source applications available to DBAs, and provides the Perl DBA Toolkit, a comprehensive suite of ready-to-use scripts designed to ease the burden of Oracle database administration.

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tuning tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

Learn how to most effectively use PL/SQL programming language with one of the most popular and widely-used software programs in large companies today -- Oracle (R)11g. ORACLE (R) 11G: PL/SQL PROGRAMMING & ORACLE (R) CD, 2E, International Edition uses Oracle (R) 11g to provide an overview of the PL/SQL programming language from a developer's perspective. The author begins with a step-by-step expanded introduction to fundamental PL/SQL concepts before progressing to the writing and testing of PL/SQL code. This edition also covers more advanced topics, such as Dynamic SQL and code tuning, as well as developments in bulk processing, compound triggers, PL/SQL compiler features and hiding source code. Updates reflect the latest Oracle (R) 11g release with the most recent figures and examples using the user-friendly SQL Developer tool. A wealth of real-world examples, a straightforward presentation, and accompanying Oracle (R) CD make this book is an invaluable resource in preparing for the new Oracle (R) Certification exam or mastering the PL/SQL programming language with Oracle (R).

Oracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital.

Implement Oracles Internet-based Manufacturing and Supply Chain Management products using this Oracle authorized resource. This comprehensive guide explains how to implement the planning, engineering, pricing, order fulfillment, and inventory management components of Oracle Manufacturing and Supply Chain--and develop and deliver goods and services faster, cheaper, and more efficiently than your competitors.

Expert Oracle Application Express Plugins is your go to book on the groundbreaking plugin architecture introduced in Oracle Application Express 4.0. Using the new APEX functionality, you can create well-packaged, documented, reusable components and reliably leverage your coding investments across many applications. Components you create can define new item and region types, specify validation processes, and present dynamic actions to client applications. You can design innovative and colorful ways to display information, such as displaying the temperature using an image of a thermometer, or displaying sales velocity in the form of an automotive speedometer. The new plugin architecture is sure to create a tidal wave of creativity. Author Martin D'Souza shows everything you need to know to get started in building and deploying plugins of your own design. You'll learn the underlying architecture, including the APIs used to tie your plugins seamlessly into an Application Express environment. You'll learn about the different types of plugins, and you'll walk through examples of each to ensure that you can create the right type of plugin when you need it. Finally, Expert Oracle Application Express Plugins shows how to work as part of the larger Application Express community by leveraging that community's efforts and by giving back as you deploy your own plugins to the broad audience of Application Express developers. Presents the architecture and APIs available for customizing Application Express Gives clear examples of plugin development, for each type of plugin Helps you work as part of the broader community of plugin developers What you'll learn Understand the APEX plugin architecture Design and develop each of the four types of plugin Debug and troubleshoot plugin-based applications Deploy your plugins to the wider community Make your plugins compatible across different browsers Master the plugin APIs that APEX provides Who this book is for

Expert Oracle APEX Plugins is aimed at Oracle Application Express developers wanting to develop reusable components using Application Express's new, plugin architecuture. The book appeals to in-house developers wanting to preserve their investment in writing code by packaging it for convenient reuse in other applications. The book also appeals to commercial software developers who want to write plugins for sale. Table of Contents Introduction to Plugins Plug-in Fundamentals Item Plug-ins Dynamic Action Plug-ins Region Plugiins Process Plugiins Best Practices & Community Debugging& Tools

Now available in paperback-- What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle Performance Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place. If you're an IT practioner who appreciates application over mathematical proofs than you'll be pleasantly surprised Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda. This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations.If you are more management-minded (or want to be), you will be delighted with the service level management focus. Forecasting makes good business sense because it maximizes the return on IT investment and minimizes unplanned down time. To those who think forecasting is a waste of money: well...obviously, they've never been on the evening news because their company lost millions of dollars in revenue and brand destruction because of poorly performing or unavailable systems. Without a doubt, you will be equipped to deal with the realities of forecasting Oracle performance. But this book gives you more. Not only will you receive a technical and mathematical perspective, but also a communication, a presentation, and a management perspective. This is career building stuff and immensely satisfying What you'll learnThis book is a how-to book filled with examples to transform theory and mathematics into something you can practically apply.You will learn how to use a variety of forecasting models, which will enable you to methodically: * Help manage service levels from a business value perspective * Identify the risk of over utilized resources * Predict what component of an architecture is at risk * Predict when a system will be at risk * Develop multiple risk mitigating strategies to ensure service levels are maintained * Characterize a complex Oracle workload Who this book is for IT professionals who must ensure their production Oracle systems are meeting service levels, in part, through forecasting performance, identifying risk, and developing solutions to ensure systems are available without wasting budget. Readers include database administrators, IT managers, developers, capacity planners, systems architects, systems integrators.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Leverage Oracle Database 11g Release 2 High Availability FeaturesProtect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource. Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version Build test clusters and hosts using Oracle VM Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System Create synchronized standby databases using Oracle Data Guard Reliably archive and restore data with Oracle Recovery Manager Use Oracle Flashback to identify and undo user errors Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment

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 What you'll learn Recognize common query patterns and apply their corresponding solutions. Solve common reporting problems such as sorting rows into buckets. Troubleshoot SQL performance problems. Create and manage database objects such as tables, indexes, and views. Work with XML and tree-structured data. Take advantage of analytic functions, regular expressions, hierarchical query support, and other powerful aspects of Oracle SQL. Who this book is for

Oracle SQL Recipes is written for developers and database administrators who write SQL to run against an Oracle database. It is further written for those whose time is precious, and who just wish for a good example to help them get on with their work. If you want to spend your time writing SQL rather than reading about it, then this is the right book for you. Table of Contents The Basics Summarizing and Aggregating Data Querying from Multiple Tables Creating and Deriving Data Common Query Patterns Working with Date and Time Values Strings Working with Numbers Managing Transactions Data Dictionary Common Reporting Problems Cleansing Data Tree-Structured Data Working with XML Data Partitioning LOBs Database Administration Object Management SQLMonitoring and Tuning Database Troubleshooting

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. 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 SQL*Plus: The Definitive Guide" clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform.

With "Oracle SQL*Plus: 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 SQL*Plus 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 SQL*Plus. 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.

Oracle Regular Expressions Pocket Reference 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.

The JDBC Pocket Reference offers quick look-ups for all methods of the standard JDBC classes. These include concise reviews of the procedures for common JDBC tasks such as connecting to a database, executing stored procedures, executing DDL and the like. You'll find documentation of the connect string formats for the most common databases, including Oracle, SQL-Server, and PostgreSQL. You'll even find information on working with large objects, and on using SQL99 user defined datatypes to work with object-relational data. Searching for this sort of material through large tutorials is frustrating and a waste of time, but this pocket-sized book is easy to take anywhere and makes finding the information you need a snap.

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

Packed with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the "Oracle Utilities Pocket Reference" close at hand.

Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The "Oracle Utilities Pocket Reference" is part of the strong-selling collection of O'Reilly "pocket reference" books.

This is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. It describes nearly 100 open source tools, from the widely applied (like Linux, Perl, and Apache) to the Oracle-specific (like Orasoft, Orac, OracleTool, and OraSnap). You'll learn where to find them, what their advantages are, and how to create and release new open source Oracle tools yourself.

A companion to Feuerstein's other bestselling Oracle PL/SQL books, this workbook presents a carefully constructed set of problems and solutions that will test your language skills and help you become a better developer. Three levels of exercises--beginner, intermediate, and expert--cover the full set of language features. These include variables, loops, exception handling, data structures, object technology, cursors, built-in functions and packages, PL/SQL tuning, and the new Oracle8i features (including Java and the Web).

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.

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92. Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQL, this book provides many examples of how to write even more advanced SQL to huge benefit in your applications, such as: Pivoting rows to columns and columns to rows Recursion in SQL with MODEL and WITH clauses Answering Top-N questions Forecasting with linear regressions Row pattern matching to group or distribute rows Using MATCH_RECOGNIZE as a row processing engine The process of starting from simpler statements in SQL, and gradually working those statements stepwise into more complex statements that deliver powerful results, is covered in each example. By trying out the recipes and examples for yourself, you will put together the building blocks into powerful SQL statements that will make your application run circles around your competitors. What You Will Learn Take full advantage of advanced and modern features in Oracle SQL Recognize when modern SQL constructs can help create better applications Improve SQL query building skills through stepwise refinement Apply set-based thinking to process more data in fewer queries Make cross-row calculations with analytic functions Search for patterns across multiple rows using row pattern matching Break complex calculations into smaller steps with subquery factoring Who This Book Is For Oracle Database developers who already know some SQL, but rarely use features of the language beyond the SQL-92 standard. And it is for developers who would like to apply the more modern features of Oracle SQL, but don't know where to start. The book also is for those who want to write increasingly complex queries in a stepwise and understandable manner. Experienced developers will use the book to develop more efficient queries using the advanced features of the Oracle SQL language.