This manual is intended for programmers, systems analysts, project managers, and others interested in the development and tuning of database applications. This manual assumes you have a working knowledge of application programming and that you are familiar with the use of structured query language (SQL) to access information In relational database systems. Certain sections of this manual also assume a knowledge of the basic concepts of object-oriented programming.

The Oracle9i Application Developer’s Guide — Advanced Queuing is intended for programmers developing new applications that use Oracle Advanced Queuing, as well as those who have already implemented this technology and now wish to take advantage of new features.

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year.Показать полностьюThe world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor. Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include: * Basic relational database concepts * Reporting and querying using SQL*Plus and iSQL*Plus * Creating and maintaining a database * Managing user access and security * Understanding Oracle database functions * Using multiple tables in a query * Restricting, sorting, and grouping data * Optimizing database performance * Creating backups * Troubleshooting database errors.

Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL *Plus and iSQL *Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL *Plus reporting techniques * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting.

Here’s the book you need to prepare for Oracle’s 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today’s racle certification candidates.Показать полностьюHere’s the book you need to prepare for Oracle’s 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today’s racle certification candidates. In addition to the consistent and ccessible instructional approach that has earned Sybex the Best Study Guide selection in CertCities Readers Choice wards for two consecutive years.

* High Performance Oracle Database Applications provides everything an Oracle professional needs to know to ensure high-quality, high-performance databases.Показать полностью* High Performance Oracle Database Applications provides everything an Oracle professional needs to know to ensure high-quality, high-performance databases. Packed with useful real-world examples, this book will optimize the user’s efforts by focusing on the handful of tuning techniques that will provide the maximum benefit. Unlike other books on Oracle performance and tuning, High Performance Oracle Database Applications explains the complex internals of the Oracle engine in simple, easy-to-understand terms, and gives the reader immediate insight into how Oracle manages data. * Teaches how table design techniques can be used to maximize Oracle performance. * Exposes the internal mechanisms of Oracle. * Provides pretested performance scripts to get immediate performance information. * Offers expert advice on interpreting Oracle performance information. * Shows how to quickly implement performance and tuning data collection without buying expensive tools. * A complete performance and tuning toolkit that will save hundreds of hours of work * Software to run performance and tuning scripts immediately on any Oracle database * Software that enables quick interpretation of all performance information * Demo of BMC’s Patrol, the world’s leading Oracle performance monitor

Oracle 9i. Heterogeneous Connectivity Administrator’s Guide is intended for the following users: ¦ Database administrators who want to administer distributed database systems that involve the following: ¦ Oracle to Oracle database links ¦ Oracle to non-Oracle database links ¦ Regular Oracle database server users who want to make use of the Heterogeneous Services feature in the Oracle database server ¦ Readers who want an high-level understanding of this product and how it works.Показать полностьюOracle 9i. Heterogeneous Connectivity Administrator’s Guide is intended for the following users: ¦ Database administrators who want to administer distributed database systems that involve the following: ¦ Oracle to Oracle database links ¦ Oracle to non-Oracle database links ¦ Regular Oracle database server users who want to make use of the Heterogeneous Services feature in the Oracle database server ¦ Readers who want an high-level understanding of this product and how it works. To use this document, you should be familiar with the following information: ¦ Relational database concepts and basic database administration as described in Oracle 9i. Dorobase Concepts and the OracleQi Database Administrator’s Guide. ¦ The operating system environment under which database administrators are running Oracle.

This guide provides an overview of the Oracle Performance Manager, Oracle Capacity Planner, Oracle E-business Management tools, Oracle Trace Data Viewer, and Oracle TopSessions charts and their features. As the guide describes how to use these applications provided with the Oracle Diagnostics Pack, it also introduces you to key concepts and terminology.

Welcome to the Oracle Workflow Guide. This guide assumes you have a working knowledge of the following: • The principles and customary practices of your business area. • Oracle Workflow. If you have never used Oracle Workflow, we suggest you attend one or more of the Oracle Workflow training classes available through Oracle University. See Other Information Sources for more information about Oracle Applications product information. The Oracle Workflow Guide also assumes you have a basic understanding of operating system concepts and familiarity with Oracle database server, PL/SQL, and Oracle^/ Application Server technology.Показать полностьюWelcome to the Oracle Workflow Guide. This guide assumes you have a working knowledge of the following: • The principles and customary practices of your business area. • Oracle Workflow. If you have never used Oracle Workflow, we suggest you attend one or more of the Oracle Workflow training classes available through Oracle University. See Other Information Sources for more information about Oracle Applications product information. The Oracle Workflow Guide also assumes you have a basic understanding of operating system concepts and familiarity with Oracle database server, PL/SQL, and Oracle^/ Application Server technology. If you have not yet been introduced to any of these systems, we suggest vou attend one or more of the training classes available through Oracle University.

This guide describes how to use Oracle interMedia Java Classes. This guide is for developers or database administrators who are interested in storing, retrieving, and manipulating multimedia data in an Oracle database, including developers of multimedia specialization applications. Users of this guide should have experience with Java and JDBC.

Welcome to the Oracle Advanced Security Administrator’s Guide for Release 9.0.1 of Oracle Advanced Security. Oracle Advanced Security contains a comprehensive suite of security features that protect enterprise networks and securely extend them to the Internet.Показать полностьюWelcome to the Oracle Advanced Security Administrator’s Guide for Release 9.0.1 of Oracle Advanced Security. Oracle Advanced Security contains a comprehensive suite of security features that protect enterprise networks and securely extend them to the Internet. It provides a single source of integration with multiple network encryption and authentication solutions, single sign-on services, and security protocols. The Oracle Advanced Security Administrator’s Guide describes how to implement, configure and administer Oracle Advanced Security. The Oracle Advanced Security Administrator’s Guide is intended for users and systems professionals involved with the implementation, configuration, and administration of Oracle Advanced Security including: ¦ Implementation consultants ¦ System administrators ¦ Security administrators

This book describes ways to improve Oracle performance by starting with good application design and using statistics to monitor application performance. It explains the Oracle Performance Improvement Method and the Emergency Performance Method, and it provides techniques for dealing with performance problems.

2-nd edition. Provides a reference to basic language elements including block structure and declarations, statements for program control, and the calling of functions.

Nearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language.Показать полностьюNearly a quarter-million PL/SQL programmers--novices and experienced developers alike--have found the first and second editions of Oracle PL/SQL Programming to be indispensable references to this powerful language. Packed with examples and recommendations, this book has helped everyone, from Oracle Forms developers to database administrators, make the most of PL/SQL. Authored by renowned PL/SQL experts Steven Feuerstein and Bill Pribyl, this new edition is a comprehensive update of the original book, covering all versions of PL/SQL through Oracle9i Release 2. It adds much-requested new chapters on how to create and run PL/SQL programs, call Java methods from within PL/SQL, and define and use database triggers. An extensive new chapter---designed especially for experienced PL/SQL developers--describes PL/SQL’s runtime architecture and how to use knowledge of Oracle internals to get the best performance from PL/SQL. Regardless of the version you are using, from Oracle 7.3.4 to Oracle 9i, this book will answer your questions.g.

This manual is your primary source of introductory and reference information for Oracle9i for Windows for both client and server. Differences between product versions are noted where appropriate. This manual describes only the features of Oracle9i Enterprise Edition, Oracle9i Standard Edition, and Oracle9i Personal Edition software that apply to the Windows 95, Windows 98, Windows NT, and Windows 2000 operating systems. This manual is intended for: ¦ Database administrators ¦ Network administrators ¦ Security specialists ¦ Developers who use the Oracle9/ database To use this document, you need: ¦ Windows NT or Windows 2000 installed and tested on your computer system ¦ Knowledge of object-relational database management concepts

Oracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It is 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.Показать полностьюOracle Regular Expressions Pocket Reference is part tutorial and part quick-reference. It is 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 10Gs support for regular expressions, including globalization support and differences between Perls 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.

Oracle9i Application Developer’s Guide — Object-Relational Features is intended for programmers developing new applications or converting existing applications to run in the Oracle environment.Показать полностьюOracle9i Application Developer’s Guide — Object-Relational Features is intended for programmers developing new applications or converting existing applications to run in the Oracle environment. The object-relational features are often used in multimedia, Geographic Information Systems (GIS), and similar applications that deal with complex data. The object views feature can be valuable when writing new applications on top of an existing relational schema. This guide assumes that you have a working knowledge of application programming and that you are familiar with the use of Structured Query Language (SQL) to access information in relational database systems.

The Oracle9i Data Cartridge Developer’s Guide describes how to build and use data cartridges to create custom extensions to the Oracle server’s indexing and optimizing capabilities.

This manual provides a detailed description of all the event tests available in the Oracle Enterprise Manager Event System. In addition to the general description of each event, event information includes data source, parameters, output, recommended frequency, and user action. This manual is written for those who need detailed information about an event used in the Oracle Enterprise Manager Event System. This manual assumes that you are familiar with the Oracle Enterprise Manager console and base applications.Показать полностьюThis manual provides a detailed description of all the event tests available in the Oracle Enterprise Manager Event System. In addition to the general description of each event, event information includes data source, parameters, output, recommended frequency, and user action. This manual is written for those who need detailed information about an event used in the Oracle Enterprise Manager Event System. This manual assumes that you are familiar with the Oracle Enterprise Manager console and base applications. If you are not, please read Oracle Enterprise Manager Concepts Guide and Oracle Enterprise Manager Administrator’s Guide.

An enormous system comprising myriad technologies, options, and releases, Oracle’s complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals.Показать полностьюAn enormous system comprising myriad technologies, options, and releases, Oracle’s complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly’s Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it. The new edition of this classic book, Oracle Essentials, 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle’s features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle’s Database 10g--the industry’s first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered.