Explaining how to create in-depth reports with Crystal Reports in an Oracle database, this helpful guide provides coverage of SQL and PL/SQL, as well as practical techniques and tools for optimizing the database and Crystal Reports process, troubleshooting tips, and more.

This manual provides case studies and applications that use Oracle 9i’s XML-enabled database technology. It describes different ways that XML data can be stored, managed, queried, and exchanged in the database using Oracle XML-enabled technology.

This manual describes Oracle 9i’s XML-enabled database technology. It describes how XML data can be stored, managed, and queried in the database using Oracle XML-enabled technology and the appropriate Oracle development tools. After introducing you to the main criteria to consider when designing your Oracle XML application, this manual describes an overview of several scenarios that are based on real-life existing business applications.Показать полностьюThis manual describes Oracle 9i’s XML-enabled database technology. It describes how XML data can be stored, managed, and queried in the database using Oracle XML-enabled technology and the appropriate Oracle development tools. After introducing you to the main criteria to consider when designing your Oracle XML application, this manual describes an overview of several scenarios that are based on real-life existing business applications. You are then introduced to the XML Developer’s Kits (XDKs) and how the XDK componoents can work together to generate and store XML data in a database. Examples and sample applications are introduced where possible. Oracle9i Case Studies — XML Applications describes case studies that use Oracle XML-enabled technology The case studies are presented according to their main function, namely, whether they are primarily used for one or both of the following: ¦ Content or Document Management ¦ Data Exchange and Business—to-Business (B2B)

Oracle 9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracle 9i and Oracle 9i Enterprise Edition products.Показать полностьюOracle 9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracle 9i and Oracle 9i Enterprise Edition products. Oracle 9i and Oracle 9i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. To use the Partitioning functionality, select the Partitioning option.

Oraclc9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracle9i and Oracle9i Enterprise Edition products.Показать полностьюOraclc9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracle9i and Oracle9i Enterprise Edition products. Oracle9i and Oracle9i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. To use the Partitioning functionality, select the Partitioning option.

Oracle 9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracled and Oracled Enterprise Edition products.Показать полностьюOracle 9i Application Developer’s Guide-Large Objects (LOBs) contains information that describes the features and functionality of Oracled and Oracled Enterprise Edition products. Oracle9i and Oracled Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional. To use the Partitioning functionality, select the Partitioning option.

Whether you're a new or experienced Oracle database application developer, you'll appreciate the insights of this book on using the advanced features of SQL*Plus and PL/SQL to speed development time, reduce maintenance costs and debugging time, and improve the overall reliability of your database applications.

The Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, instance parameters controlling I/O, SGA performance, and object sizing, placement, and reorganization.Показать полностьюThe Oracle Tuning Pack provides advanced tools that focus on tuning the highest impact database performance areas, such as: application SQL, indexing strategies, instance parameters controlling I/O, SGA performance, and object sizing, placement, and reorganization. The tools included in this pack are designed to work together to accomplish many database tuning tasks. The applications included in the Oracle Tuning Pack are: Oracle SQL Analyze. Oracle Expert, Outline Editor, Outline Management, Oracle Index Tuning Wizard, Reorg Wizard, and the Tablespace Map.

This guide is ycnir primary source of introductory, post-installation, configuration, and administration information for using Oracle9i network, directory, and security features for Windows operating systems. This guide is necessary for anyone configuring or administering Oracle9i network, directory, and security features for Windows operating systems.

This guide is your primary source of introductory, postinstallation, configuration, and administration information for using Oracle9i Enterprise Edition, Oracle9i Standard Edition, or Oracle9i Personal Edition.Показать полностьюThis guide is your primary source of introductory, postinstallation, configuration, and administration information for using Oracle9i Enterprise Edition, Oracle9i Standard Edition, or Oracle9i Personal Edition. Differences between the three versions are noted where appropriate. This guide is necessary for anyone installing, configuring, or administering Oracle9i Enterprise Edition, Oracle9i Standard Edition or Oracle9i Personal Edition.

This guide is the primary source of introduction, installation, configuration, usage, and administration information for using Microsoft Transaction Server with Oracle. Oracle Developer’s Guide for Microsoft Transaction Server is intended for application developers who perform the following tasks: ¦ Use component object model (COM) components with Microsoft Transaction Server ¦ Register COM components as transactional and have Microsoft Transaction Server control the transaction ¦ Use client-side connection pooling in Microsoft Transaction Server

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions is the definitive book if you're a developer or DBA who works with Oracle-driven database applications.Показать полностьюExpert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions is the definitive book if you're a developer or DBA who works with Oracle-driven database applications. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. One of the world’s foremost Oracle experts, Thomas Kyte covers every important feature and function of the database: the importance, inner workings, proper usage, and pitfalls if handled incorrectly. This book will show you how to program correctly with the Oracle database and exploit its feature-set effectively. As a result, you will be able to build fast, effective, scalable, and secure Oracle applications.

Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment.Показать полностьюTom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter course, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Tom has selected the most important features and techniques and he teaches them in a proof-by-example manner, not only discussing the features available, but also how to implement software using them and indicating the potential pitfalls. This book covers: Core database structures and utilities Performance tuning Advanced SQL features Extensibility using C, Java and OR features Security Important supplied packages

In addition to providing developers with detailed coverage of the PL/SQL 9i language, the author of this text covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications.

Oracle Developer Forms Techniques describes the concepts and techniques needed to build Web-enabled applications with Forms. The book covers advanced topics in great detail, including understanding and overcoming error handling limitations in Forms, such as errors which cannot be tracked through normal FORM_SUCCESS or FORM_FAILURE, ordering by items based on FK look-ups, obtaining Query Count without actually executing a query, and performing an exclusive server-side commit from Forms.Показать полностьюOracle Developer Forms Techniques describes the concepts and techniques needed to build Web-enabled applications with Forms. The book covers advanced topics in great detail, including understanding and overcoming error handling limitations in Forms, such as errors which cannot be tracked through normal FORM_SUCCESS or FORM_FAILURE, ordering by items based on FK look-ups, obtaining Query Count without actually executing a query, and performing an exclusive server-side commit from Forms. The book also covers object-oriented methods in Forms, and Intelligence in Forms. Code segments are provided to help developers implement these techniques, thus easing application development time and effort.

Oracle9i Data Warehousing Guide is intended for database administrators, system administrators, and database application developers who perform the following tasks: ¦ design, maintain, and use data warehouses. To use this document, you need to be familiar with relational database concepts, basic Oracle server concepts, and the operating system environment under which you are running Oracle.

This manual is written for database administrators, system administrators, and database application developers who need to ensure that their database or applications include globalization support. To use this document, you need to be familiar with relational database concepts, bask Oracle server concepts, and the operating system environment under which you are running Oracle. In addition to administrators, experienced users of Oracle and advanced database application designers will find information in this manual useful.Показать полностьюThis manual is written for database administrators, system administrators, and database application developers who need to ensure that their database or applications include globalization support. To use this document, you need to be familiar with relational database concepts, bask Oracle server concepts, and the operating system environment under which you are running Oracle. In addition to administrators, experienced users of Oracle and advanced database application designers will find information in this manual useful. However, database application developers should also refer to the 0raclc9i Application Developer’s Guide — Fundamentals and to the documentation for the tool or language product they are using to develop Oracle database applications.

The insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder.Показать полностьюThe insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder. Both groups will become better troubleshooters — Thomas Kyte, VP (Public Sector), Oracle Corporation The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns&emdash;and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong? If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. You'll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL. The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect. In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewis&emdash;one of the foremost authorities in this field&emdash;describes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, you'll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals..

This reference contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle database. Oracle SQL is a superset of the American National Standards Institute (ANSI) and the International Standards Organization (ISO) SQL99 standard.