Oracle® Database SQL Reference 10g Release 2

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) SQL:1999 standard.

The Oracle Database SQL Reference is intended for all users of Oracle SQL.

For more information, see these Oracle resources:

• PL/SQL User's Guide and Reference for information on PL/SQL, the procedural language extension to Oracle SQL
• Pro*C/C++ Programmer's Guide, Oracle SQL*Module for Ada Programmer's Guide, and the Pro*COBOL Programmer's Guide for detailed descriptions of Oracle embedded SQL

Many of the examples in this book use the sample schemas, which are installed by default when you select the Basic Installation option with an Oracle Database installation. Refer to Oracle Database Sample Schemas for information on how these schemas were created and how you can use them yourself.

Click to Read More

Oracle PL/SQL Built-ins Pocket Reference

By Steven Feuerstein, John Beresniewicz and Chip Dawes

The Oracle PL/SQL Built-ins Pocket Reference is a quick reference guide to the many built-in packages and functions provided by Oracle Corporation. It contains a concise description of the syntax for the following:

• Built-in packages
• Built-in functions
• RESTRICT REFERENCES pragmas for the built-in packages
• Nonprogram elements (e.g., constants, exceptions, etc.) defined in the built-in packages

Although we don't include every single package and function in this pocket reference, we've included all the built-ins that most PL/SQL developers will ever need to use.

The purpose of this pocket reference is to help PL/SQL users find the syntax of specific built-in headers. It is not a self-contained user guide; basic knowledge of PL/SQL and its built-ins is required. For more information, see the following books:

• Oracle PL/SQL Programming, by Steven Feuerstein and Bill Pribyl (O'Reilly & Associates, Second Edition, 1997).
• Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly & Associates, 1998).

Click to Read More

Oracle PL/SQL Language Pocket Reference

By Steven Feuerstein, Bill Pribyl and Chip Dawes

The Oracle PL/SQL Language Pocket Reference is a quick reference guide to the PL/SQL programming language, which provides procedural extensions to the SQL relational database language and a range of Oracle development tools.

Where a package, program, or function is supported only for a particular version of Oracle (e.g., Oracle8i), we indicate this in the text.

The purpose of this pocket reference is to help PL/SQL users find the syntax of specific language elements. It is not a self-contained user guide; basic knowledge of the PL/SQL programming language is required.

For more information, see the following books:

• Oracle PL/SQL Programming, 2nd Edition, by Steven Feuerstein with Bill Pribyl (O'Reilly & Associates, 1997).
• Oracle Built-in Packages, by Steven Feuerstein, Charles Dye, and John Beresniewicz (O'Reilly & Associates, 1998).
• Oracle PL/SQL Built-ins Pocket Reference, by Steven Feuerstein, John Beresniewicz, and Chip Dawes (O'Reilly & Associates, 1998).

Click to Read More

Oracle Web Applications PL/SQL Developer's Introduction

By Andrew Odewahn

The goal of Oracle Web Applications is to help Oracle SQL and PL/SQL developers who have little or no web programming experience to learn to develop useful web applications, using technologies most IS developers can grasp fairly quickly: WebDB, Oracle Application Server (OAS), PL/SQL, HTML, and XML.

In addition, the book introduces several other Oracle8i technologies -- Advanced Queuing (AQ), the Internet File System (iFS), interMedia, InternetLite, and Java(TM) -- and shows how they form a cohesive development framework that addresses the pressing issues of web content management, application development, and application integration. While there have been many changes in Oracle8i, it's still just a database, and there's no need to panic: data is data, whether it comes from the accounts payable system or from the Internet.

This book acknowledges that you're a busy person. Since most of us simply don't have time to read and digest an 800-page book on each individual technology, I've tried to present fundamental elements of the topics you'll use most often in your daily development efforts. This book will get you started and solidly on your way, but it's not, obviously, the ultimate reference. Rather, it is a "Cliff Notes" of Oracle web development -- enough to help you pass the test, but not enough to help you appreciate the finer points. Once you've read the book, however, you'll be ready to delve into the various areas (WebDB, PL/SQL, Java, etc.) more deeply. Your first step on that journey should be to consult the appendix for information on further resources.

Click to Read More

Advanced Oracle PL/SQL Programming with Packages

By Steven Feuerstein

Who would have thought that just one year after the publication of Oracle PL/SQL Programming, a 916-page tome on "everything PL/SQL", I'd end up writing a second book about the PL/SQL language? Although back in September 1995 I wasn't arrogant enough to think that I knew all there was to know about PL/SQL, I also underestimated how much more I had still to learn!

I am firmly of the belief that one never stops learning -- as long as one is open to learning. The area of PL/SQL in which I needed lots more education turned out to be packages. In my first book I explained how to build and use packages. I even provided lots of examples of package construction. But I started to realize that this wasn't enough. Over the past year, I have been designing and developing a set of packages to help me build PL/SQL-based applications. This was a thoroughly selfish effort: I wanted to be as productive as possible, and I wanted to overcome a number of weaknesses -- however transient -- in the PL/SQL language. In the process of writing this software, I learned a good deal about the best ways to build PL/SQL code, especially regarding packages. I also discovered some very interesting techniques that can make packaged software more maintainable, accessible, and easy to use.

As my thinking on the construction of packages crystallized, I began to view all of my packages as a library of code that could be used by any PL/SQL developer. I also realized that I wanted to share the new techniques and lessons I had uncovered. The result? This book and the PL/Vision product.

How often do you find yourself writing a program and simultaneously thinking: somebody must have done this before! You feel certain that you are reinventing the wheel. Worse, if you are sufficiently honest with yourself, you will also admit that someone else has probably spent more time on the problem and has already come up with a better solution than you are likely to develop for your specific application.

Often, you know you should take the time to "genericize" a program so that you can use it again and again in different circumstances. Somehow, however, you never find the time -- and the mental space -- to take your code to that higher level of abstraction.

So you limp along, accepting a relatively low level of productivity and reusing a truly minimal amount of code. You write the same things over and over and simply push aside the feeling that you are wasting your time.

Oracle developers are fortunate to be able to use an advanced, robust language like PL/SQL. PL/SQL developers are, on the other hand, less than fortunate (at least as of September 1996) to find that the supporting environment for PL/SQL is still very immature. Where are the debuggers, the code formatters and generators, the toolboxes of reusable programs and objects? When will we have a powerful editor that knows about PL/SQL syntax and -- more importantly -- the stored code available for execution?

When, you might also ask, will this guy stop complaining? It is acceptable to identify weaknesses. It is constructive to analyze areas for improvement. At some point, however, you have to stop whining and start improving things for yourself. Best yet, keep on whining but engage in self-improvement at the same time!

This book will help you write better packages. It will also show you how to use the "prebuilt" packages of the PL/Vision software product -- my attempt to change the "situation on the ground" for PL/SQL programmers. Finally, I hope that it will, via examination of my source code and the way I separated functional areas in PL/Vision, offer a blueprint for PL/SQL developers to discover how to take full advantage of PL/SQL packages in their day-to-day programming.

Click to Read More

Oracle Built-in Packages

By Steven Feuerstein, Charles Dye and John Beresniewicz

After publishing more than 1,600 pages on Oracle PL /SQL in two previous books, I marvel at the existence now of this third book covering yet other aspects of the PL /SQL language. I can still remember quite distinctly a moment in September, 1994, when I embarked on writing the first draft of Oracle PL /SQL Programming and wondered: are there really 400 pages worth of material on that much-used and often-maligned procedural language from a nonprocedural (SQL) company? If the answer to that question was a resounding "yes" in 1994, then the answer is a deafening roar today!

Maybe PL /SQL isn't the answer to every object-oriented programmer's deepest desires. Maybe developers are badly in need of -- and unreservedly deserve -- better tools with which to write, debug, and reuse PL /SQL programs. Maybe PL /SQL isn't perfect, but the reality is that hundreds of thousands of people around the world work (and struggle) with PL /SQL on a daily basis. We all need as much information as possible about how we can make the best possible use of Oracle PL /SQL.

And that is the objective of Oracle Built-in Packages. If you are going to build complex applications using PL /SQL, you will not succeed unless you learn about and figure out how to utilize many of the packages described in this book. Packages are the method of choice for Oracle and third parties like RevealNet, Inc., to extend the base PL /SQL language, to improve ease of use, and to provide brand-new functionality in the language. Writing PL /SQL code without knowing about or using built-in packages is akin to building an automobile and ignoring the last 20 years of technological advances. The resulting machine will run more slowly, use more gas, and be harder to repair.

Oracle Built-in Packages grew out of Chapter 15 of the first edition of Oracle PL /SQL Programming. When Oracle released Oracle8, it was time to update that book to include the wide-ranging new PL /SQL8 functionality. It was clear from the start that this second edition, if organized like the first, would have been well over 1,500 pages in length -- a totally impractical size for a developer's handbook.

What to do? Based on feedback from developers about Oracle PL /SQL Programming, there was an enormous amount of interest in, and often confusion surrounding, the built-in packages. These Oracle-provided "add-ons" to PL /SQL clearly needed more detailed coverage, more examples, more tips, more of just about everything. My single chapter of 100 pages was woefully inadequate. We made the decision to move that single chapter out of Oracle PL /SQL Programming and expand it into a book all its own. You are holding the result.

I recognized early in the process that I couldn't personally cover all of the Oracle built-in packages discussed in this book. I didn't have the necessary expertise, nor the time to learn, nor the time to write it all. So I sought and received the help of two excellent Oracle technologists: John Beresniewicz and Charles Dye.

Over the past six months, John, Charles, and I have researched the packages provided by Oracle in the database, verified the documentation, uncovered aberrant behavior, and discovered neat tricks. We also made it a priority to construct package-based utilities that you will be able to put to immediate use.

While Oracle Built-in Packages is a collaborative effort, it is also a combination of very individual efforts. As such, you will find differences in coding styles and philosophies. Rather than try to enforce a single standard throughout, I welcomed the variations (as long as all contributed in their own way to a deeper, clearer understanding of the PL /SQL technology). There is rarely a single right way to do anything, and there is an enormous amount we can learn from the different journeys each of us takes to a solution.

Click to Read More

Oracle PL/SQL Programming - Guide to Oracle8i Features

By Steven Feuerstein

2700 pages and still writing! Sometimes I feel like the Energizer Bunny of PL/SQL. But Oracle keeps the features coming, and after all these years, I'm still enthusiastic about what PL/SQL can do to improve the quality of life for developers. Even with the coming of Java(TM) in Oracle8i, I believe strongly that the future is bright for PL/SQL developers.

This short book is something of a departure for me -- those of you who have read my larger tomes may wonder if I've found a ghostwriter! Now that Oracle8i is here, it's my intention to update Oracle PL/SQL Programming (now in its second edition) to cover the new version of the Oracle database. Along with developing a third edition of that book (with my coauthor Bill Pribyl), I'm taking a critical look at all of my books to make sure that the O'Reilly & Associates PL/SQL series offers a comprehensive resource for PL/SQL developers.

For now, though, PL/SQL developers need current and useful information about the latest PL/SQL features; there are a lot of them, and some represent major changes in the language. This small book is intended to get you started on understanding these features and using them to best advantage.

For many people, the big news about Oracle8i is Java, and the big question for many PL/SQL developers is how (and whether) to use Java in conjunction with PL/SQL. Chapter 9, Calling Java from PL/SQL, is a roadmap showing PL/SQL developers how to employ Java right now. It doesn't attempt to teach you the basics of Java -- there are many other books that serve that purpose -- but it does teach you how to access Java from within PL/SQL.

Click to Read More

Oracle PL/SQL Programming Second Edition

By Steven Feuerstein and Bill Pribyl

What, specifically, will this book help you do?
Take full advantage of PL/SQL. The reference manuals may describe all the features of the PL/SQL language, but they don't tell you how to apply the technology. In fact, in some cases, you'll be lucky to even understand how to use a given feature after you've made your way through the railroad diagrams. Books and training courses tend to cover the same standard topics in the same limited way. In this book, we'll venture beyond to the edges of the language, to the nonstandard ways in which a particular feature can be tweaked to achieve a desired result.

Use PL/SQL to solve your problems. You don't spend your days and nights writing PL/SQL modules so that you can rise to a higher plane of existence. You use PL/SQL to solve problems for your company or your customers. In this book, I try hard to help you tackle real-world problems, the kinds of issues developers face on a daily basis (at least those problems that can be solved with mere software). To do this, I've packed the book with examples -- not just small code fragments, but complete application components you can apply immediately to your own situations. There is a good deal of code in the book itself, and much more on the disk that accompanies the book. In this book I guide you through the analytical process used to come up with a solution. In this way I hope you'll see, in the most concrete terms, how to apply PL/SQL features and undocumented applications of those features to a particular situation.

Write efficient, maintainable code. PL/SQL and the rest of the Oracle products offer the potential for incredible development productivity. If you aren't careful, however, this rapid development capability will simply let you dig yourself into a deeper, darker hole than you've ever found yourself in before. I would consider this book a failure if it only ended up helping programmers write more code in less time than ever before. I want to help you develop the skills and techniques that give you the time to build modules which readily adapt to change and are easily understood and maintained. I want to teach you to use comprehensive strategies and code architectures which allow you to apply PL/SQL in powerful, general ways to many of the problems you will face.

Click to Read More

Oracle Data Warehousing Unleashed

By Bonnie O'neill et al

You have decided to embark on a data warehouse journey. You are probably a little scared and overwhelmed by the immensity of the project in front of you. You are probably also wondering where to start.

This book is designed to be a definitive reference guide for all project staff having anything to do with the data warehouse. Here is an overview of the types of job classes that would benefit from this book:

Project managers: The book provides a chapter on project management, and one of the appendixes has a task checklist to assist you. The methodology and architecture chapters help you in understanding what you are going to build and some best-practice guidelines in how to do it. In addition, the rest of the book, while geared for a more technical audience, can give you a feel for what to expect and what kinds of obstacles you will likely encounter throughout the expedition.

Data administrators: A few chapters are designed especially for you: "Data Integration: The Challenges," "Defining Your Data," "Metadata," and the database design chapters. You might also find the architecture and methodology chapters interesting.
Quality analysts: the data integration, metadata, and data scrubbing chapters are right up your alley.

DBAs: Many chapters are of interest to DBAs, including (but not limited to) storage concerns, physical database design, exploiting parallel technology, indexes, kernel performance tuning, and security.

Application architects and developers: There are lots of chapters that help you get a feel for how to exploit the warehouse so the end user can get the maximum benefit possible. Some of these chapters are "Using the Intranet," "Front-End Tools," "Tuning Queries," and "Data Mining."

Data warehouse architects: The book contains a wealth of architecture and methodology information, and also discusses related constructs tangential to the data warehouse, including the operational data store and data marts.

Click to Read More

Sams Teach Yourself SQL in 24 Hours

By Ron Plew and Ryan Stephens

Who Should Read This Book?
Welcome to the world of relational databases and SQL! This book is written for those self-motivated individuals out there who would like to get an edge on relational database technology by learning the Structured Query LanguageSQL. This book was written primarily for those with very little or no experience with relational database management systems using SQL. This book also applies to those who have some experience with relational databases but need to learn how to navigate within the database, issue queries against the database, build database structures, manipulate data in the database, and more. This book is not geared toward individuals with significant relational database experience who have been using SQL on a regular basis.

What This Book Intends to Accomplish
This book was written for individuals with little or no experience using SQL or those who have used a relational database, but their tasks have been very limited within the realm of SQL. Keeping this thought in mind, it should be noted up front that this book is strictly a learning mechanism, and one in which we present the material from ground zero and provide examples and exercises with which to begin to apply the material covered. This book is not a complete SQL reference and should not be relied on as a sole reference of SQL. However, this book combined with a complete SQL command reference could serve as a complete solution source to all of your SQL needs.

What We Added to This Edition
This edition contains the same content and format as the first and second editions. We have been through the entire book, searching for the little things that could be improved to produce a better edition. We have also added concepts and commands from the new SQL standard, SQL3, to bring this book up to date, making it more complete and applicable to today's SQL user. The most important addition was the use of MySQL for hands-on exercises. By using an open source database such as MySQL, all readers have equal opportunity for participation in hands-on exercises.

What You Need
You may be wondering, what do I need to make this book work for me? Theoretically, you should be able to pick up this book, study the material for the current hour, study the examples, and either write out the exercises or run them on a relational database server. However, it would be to your benefit to have access to a relational database system to which to apply the material in each lesson. The relational database to which you have access is not a major factor because SQL is the standard language for all relational databases. Some database systems that you can use include Oracle, Sybase, Informix, Microsoft SQL Server, Microsoft Access, MySQL, and dBASE.

Click to Read More

Sams Teach Yourself Microsoft SQL Server 7 in 21 Days

By Richard Waymire and Rick Sawtell

Welcome to Sams Teach Yourself Microsoft SQL Server 7.0 in 21 Days. We hope this book will help not only teach you about SQL Server but also prove valuable for everyday work involving SQL Server. We have worked hard to see that the skills you learn from this book will easily translate into real-world methods and solutions.

There are certain skills you need to successfully install, administer, troubleshoot, and configure SQL Server. The kinds of skills you must know can be divided into two general categories:

• SQL Server programmer
• SQL Server administrator

Note
In a small company, the developer, programmer, and administrator might be the same person; large companies usually have the functions separate.

A SQL Server developer is generally responsible for designing, programming, and populating the database. Sams Teach Yourself Transact-SQL in 21 Days is a great place to start for beginning SQL programmers. After the database has been created, responsibility for the database is often turned over to an administrator, who takes care of the ongoing maintenance.

A SQL Server administrator is usually responsible for the day-to-day administration of the database. This book is designed more for administrators, although many lessons apply to programmers as well. Although some administrators might never have to do any SQL programming, we have these lessons in enough detail so that administrators can begin to pick up on SQL programming if they want to. Programming tasks covered here relate to skills administrators might be called on to perform—such as creating tables, creating indexes, and writing complex queries.

Click to Read More

Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World

Data warehouses in the 1990s were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher levels of RDBMS scalability and ease of use, being delivered through Web portals.

To support this emerging e-Business Intelligence world, the challenges that face the enterprises for their centralized data warehouse RDBMS technology are scalability, performance, availability and smart manageability.

This IBM Redbook focuses on the innovative technical functionalities of DB2 UDB ESE V8.1 and discusses:

• Guidelines on building the large database and determining the number of partitions
• Bulk load using the new multipartition load
• Performance enhancements using MultiDimensional Clustering and Materialized Query Tables.
• Availability through the new online utilities
• Self Managing And Resource Tuning features
• Migration scenarios

This book positions the new functionalities, so you can understand and evaluate their applicability in your own enterprise data warehouse environment, and get started prioritizing and implementing them.

Click to Download

Data Modeling Techniques for Data Warehousing

This redbook gives detail coverage to the topic of data modeling techniques for data warehousing, within the context of the overall data warehouse development process.

The process of data warehouse modeling, including the steps required before and after the actual modeling step, is discussed. Detailed coverage of modeling techniques is presented in an evolutionary way through a gradual, but well-managed, expansion of the content of the actual data model.

Coverage is also given to other important aspects of data warehousing that affect, or are affected by, the modeling process. These include architecting the warehouse and populating the data warehouse.

Guidelines for selecting a data modeling tool that is appropriate for data warehousing are presented.

Click to Download

Information Retrieval

By C. J. van RIJSBERGEN

The material of this book is aimed at advanced undergraduate information (or computer) science students, postgraduate library science students, and research workers in the field of IR. Some of the chapters, particular chapter 6 (this became chapter 7 in the second edition), make simple use of a little advanced mathematics. However, the necessary mathematical tools can be easily mastered from numerous mathematical texts that now exist and, in any case, references have been given where the mathematics occur.

Information retrieval is a wide, often loosely-defined term but in these pages I shall be concerned only with automatic information retrieval systems. Automatic as opposed to manual and information as opposed to data or fact. Unfortunately the word information can be very misleading. In the context of information retrieval (IR), information, in the technical meaning given in Shannon's theory of communication, is not readily measured (Shannon and Weaver). In fact, in many cases one can adequately describe the kind of retrieval by simply substituting 'document' for 'information'. Nevertheless, 'information retrieval' has become accepted as a description of the kind of work published by Cleverdon, Salton, Sparck Jones, Lancaster and others. A perfectly straightforward definition along these lines is given by Lancaster: 'Information retrieval is the term conventionally, though somewhat inaccurately, applied to the type of activity discussed in this volume. An information retrieval system does not inform (i.e. change the knowledge of) the user on the subject of his inquiry. It merely informs on the existence (or non-existence) and whereabouts of documents relating to his request.' This specifically excludes Question-Answering systems as typified by Winograd and those described by Minsky. It also excludes data retrieval systems such as used by, say, the stock exchange for on-line quotations.

Click to Read More

ORACLE Documentation (Absolute Unique Library)

This page contains links to the most current documentation for Oracle Database, Application Server, Developer Suite, Collaboration Suite and Applications/E-Business Suite.

Database

Oracle Database 10g Release 2
Oracle Gateways 10g Release 2
Oracle Database Lite 10g Release 2
Oracle Content Database 10g Release 1
Oracle Database 10g Release 1
Oracle Gateways 10g Release 1
Oracle9i Database Release 2
Oracle9i Database Release 1
Oracle Gateways for Oracle9i (Rel. 1&2)
Oracle interMedia
Oracle Spatial
Oracle Fail Safe
Oracle TimesTen In-Memory Database
Oracle Berkeley DB
Oracle Berkeley DB Java Edition
Oracle Berkeley DB XML
Oracle 10g R2 Lite
Oracle 9i Lite
Oracle Secure Backup
Oracle Application Express

Enterprise Management

Oracle Enterprise Manager 10g Release 3 (10.2)
Oracle Enterprise Manager 10g Release 1 (10.1)
Oracle Enterprise Manager Release 2.(9.2)
Oracle Enterprise Manager (Rel. 9.0.2 & 9.0.1)

Secure Enterprise Search

Oracle Secure Enterprise Search 10g

Tape Backup

Oracle Secure Backup

Technologies / Utilities

BLAF
Oracle Configuration Manager
Oracle Help Technologies
Oracle JSP Engine
Oracle Migration Tools
Oracle ODBC Drivers

Applications

E-Business Suite

Applications Releases 11i and 12

PeopleSoft Enterprise
PeopleSoft Enterprise
Archive PeopleSoft Enterprise

JD Edwards EnterpriseOne
JD Edwards EnterpriseOne
Archive JD Edwards EnterpriseOne

Oracle Retail
Oracle Retail

Siebel Applications
Siebel Applications
Siebel Integrations

Other Applications
Oracle Transportation Management (OTM) 5.5
Oracle Transportation Management (G-Log GC3) 5.0
Pharmeceutical
Oracle Demantra
Oracle Workforce Scheduling

Middleware

Application Server

Oracle Identity Management 10g (10.1.4)
Oracle Application Server 10g Release 3 (10.1.3.2)
Oracle Application Server 10g Release 3 (10.1.3.1)
Oracle Application Server 10g Release 3 (10.1.3)
Oracle Application Server 10g Release 2 (10.1.2.0.2)
Oracle Application Server 10g Release 2 (10.1.2)
Oracle Content Management SDK, 10g (9.0.4.2)
Oracle Application Server Release 10g (9.0.4)
Oracle Content Management SDK, 10g (9.0.4)
Oracle Forms 10g (10.1.2 and 9.0.4) and Oracle9i Forms (9.0.2)
Oracle9i Application Server Release 2
Oracle Content Management SDK
Oracle9i Application Server Release 1
Oracle Internet File System
Oracle Identity Manager
Internet Application Server 8i

Oracle Collaboration Suite

Oracle Collaboration Suite 10g Release 1
Oracle Collaboration Suite Release 2
Oracle Collaboration Suite Release 1

Development Tools

Oracle Developer Suite Release 10g Release 2
Oracle Developer Suite Release 10g
Oracle9i Developer Suite Release 2
Oracle9i JDeveloper
Oracle9i Developer Suite Release 1
Oracle9i Internet Developer Suite Release 1.0.2.4.1
Internet Developer Suite Release 1.0.1
Internet Developer Suite Release 1.0
Oracle Designer
Oracle SCM (Repository)
Oracle Reports
Oracle Forms

Data Warehousing and Business Intelligence

Oracle Business Intelligence
Oracle Business Intelligence Standard Edition
Oracle Business Intelligence Enterprise Edition
Oracle Business Intelligence Applications
Oracle BI Beans
Oracle Data Mining
Oracle OLAP
Oracle Warehouse Builder
Oracle Discoverer
Oracle Express Analyzer/Objects
Oracle Express Server
Oracle Express Web Agent
Oracle Data Mart Suite
Oracle Financial Analyzer
Oracle Reports

On Demand
Oracle E-Business Suite On Demand
Oracle Technology On Demand

Previously Released Oracle Documentation

Database

Oracle8i Database
Oracle8i Database Release 8.1.7
Oracle8i Database Release 8.1.6
Oracle8i Database Release 8.1.5
Oracle8 Database
Oracle8 Database Release 8.0.6
Oracle8 Database Release 8.0.5
Oracle8 Database Release 8.0.4
Oracle7 Release 7.3.4
Oracle Enterprise Manager and Management Packs
Release 2.x
Release 1.x
Oracle Gateways
Oracle Rdb

Data Warehousing and Business Intelligence

Oracle Reports
Oracle Darwin

Application Server

Oracle Application Server
Oracle Forms Services
Oracle Forms 6i
Oracle Forms Archive
Oracle Portal
Oracle9iAS Portal Center
Oracle9iAS Clickstream Intelligence
Oracle9iAS Personalization
Oracle Internet File System
Oracle Unified Messaging
Oracle Internet Directory
Oracle eMail Server
Oracle8i and 9iAS Appliance

Oracle Database 10g Release 1 (10.1) Documentation Library

Welcome to the Oracle Database 10g Documentation Library. Here you can research new information, look up reference information, and search across the entire library.

Getting Started

These books provide background information for new users:
2 Day DBA HTML PDF
Concepts HTML PDF
Administrator's Guide HTML PDF
Master Glossary HTML

Most Popular
These books contain the most commonly used information for general database administration and application development:
2 Day DBA HTML PDF

Concepts HTML PDF
Administrator's Guide HTML PDF
Application Developer's Guide - Fundamentals HTML PDF
Reference HTML PDF
Performance Tuning Guide HTML PDF
PL/SQL User's Guide and Reference HTML PDF
SQL Reference HTML PDF

Upgrade Information

If you are familiar with earlier Oracle releases and are moving to Oracle Database 10g, these books describe the new features, and explain how to upgrade your database.
New Features Guide HTML PDF
Upgrade Guide HTML PDF

License Information

This book explains how certain database features are licensed:
Licensing Information HTML PDF

Companion CD Installation Guides
The Companion CD Installation Guides cover the software other than the main database server. This software works in conjunction with the database, and requires a separate, optional installation. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.

Companion CD Installation Guide for 64-Bit WindowsHTML PDF
Companion CD Installation Guide for Linux x86-64 HTML PDF
Companion CD Installation Guide for UNIX Systems HTML PDF
Companion CD Installation Guide for Windows HTML PDF
Companion CD Quick Installation Guide for 64-Bit Windows HTML PDF
Companion CD Quick Installation Guide for AIX-Based Systems HTML PDF
Companion CD Quick Installation Guide for HP Tru64 UNIX HTML PDF
Companion CD Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Companion CD Quick Installation Guide for Linux x86 HTML PDF
Companion CD Quick Installation Guide for Linux x86-64 HTML PDF
Companion CD Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Companion CD Quick Installation Guide for Windows HTML PDF

Quick Installation Guides

The Quick Installation Guides cover the basics of installing on a clean machine, using a specific operating system.

Quick Installation Guide for 64-Bit Windows HTML PDF
Quick Installation Guide for AIX-Based Systems HTML PDF
Quick Installation Guide for HP Tru64 UNIX HTML PDF
Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Quick Installation Guide for Linux x86 HTML PDF
Quick Installation Guide for Linux x86-64 HTML PDF
Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Quick Installation Guide for Windows HTML PDF
Real Application Clusters Quick Installation Guide for Oracle Database Standard Edition for Windows HTML PDF

Installation Guides
The full Installation Guides cover a wide variety of installation scenarios. Use them if your situation is not covered in the Quick Installation Guides.

Enterprise Manager Grid Control Installation and Basic Configuration HTML PDF
Installation Guide for 64-Bit Windows HTML PDF
Installation Guide for Linux x86-64 HTML PDF
Installation Guide for UNIX Systems HTML PDF
Installation Guide for Windows HTML PDF
Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows HTML PDF
Real Application Clusters Installation and Configuration for All Platforms HTML PDF
Real Application Clusters Installation and Configuration for Linux x86-64 HTML PDF
Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows HTML PDF
Universal Installer Concepts Guide HTML PDF

Client Installation Guides
The Client Installation Guides cover the simplified install for just the Oracle client software, which lets you connect to a database running on a different system, using a database application or the interactive SQL*Plus tool. Again, there is a set of Quick Installation Guides for typical scenarios, and a full Installation Guide for advanced scenarios.

Client Installation Guide for 64-Bit Windows HTML PDF
Client Installation Guide for Linux x86-64 HTML PDF
Client Installation Guide for UNIX Systems HTML PDF
Client Installation Guide for Windows HTML PDF
Client Quick Installation Guide for 64-Bit Windows HTML PDF
Client Quick Installation Guide for AIX-Based Systems HTML PDF
Client Quick Installation Guide for HP-UX PA-RISC (64-Bit) HTML PDF
Client Quick Installation Guide for Linux x86 HTML PDF
Client Quick Installation Guide for Linux x86-64 HTML PDF
Client Quick Installation Guide for Solaris Operating System (SPARC) HTML PDF
Client Quick Installation Guide for Windows HTML PDF
Client Quick Installation Guide HP Tru64 UNIX HTML PDF

Teach Yourself Oracle 8 In 21 Days

By Edward Whalen

Contributing Author: Steve Adrien DeLuca

I have worked with Oracle for many years. Every time a new version is released or a new problem crops up, I am rejuvenated; I become excited about working with Oracle again. I want to share this enthusiasm with you, and I hope that after you become familiar with Oracle, more and more aspects of the Oracle RDBMS will interest you. The most important thing is that you enjoy what you are doing; I hope that you enjoy working with Oracle as much as I do.

The Oracle RDBMS is an enormous environment with unlimited potential. When you start working with Oracle, you might find it overwhelming. Don't give up; you will see how the different components work together as you learn about the Oracle RDBMS. Rarely do I undertake a project without learning something new about Oracle.

This book is designed for inexperienced Oracle users. Experienced Oracle DBAs will likely find this book too elementary. Most of the lessons are designed to step the reader through specific administrative and user tasks.

The best way to use this book is to read each lesson, then practice the techniques and tasks outlined in that lesson. Each lesson covers a single topic, so some lessons might be longer than others. If you complete one lesson per day, you can easily complete the full course in three weeks.

At the end of each lesson, you'll find a series of questions and answers. These questions are designed to point out some of the key concepts that were covered in the lesson. Following the Q&A section, you'll find a series of quiz questions that focus on techniques and tasks covered in the lesson. Each lesson also includes a series of exercises that are intended to familiarize you with some of the key tasks covered in that lesson.

Click to Read More

Microsoft® Access 97 Quick Reference

By Rick Winter

The Microsoft Access 97 Quick Reference is the latest in a series of comprehensive, task-oriented references and details how to use the features and functionality of Access 97. Compiled for the intermediate-to-advanced user who wants a concise, comprehensive reference, the Microsoft Access 97 Quick Reference is loaded with detailed instructions outlining important tasks you need to complete.

The Microsoft Access 97 Quick Reference presents the tasks and functions most often sought by users of Access 97. The book also includes a comprehensive glossary with many terms and definitions that refer to the newest features in Access 97.

The Microsoft Access 97 Quick Reference is written for casual to advanced computer users who need a fast reference to Access 97 tasks, functions, and features. It is an ideal companion to Que's Special Edition Using Microsoft Access 97. The Quick Reference size makes it ideal for travel.

If you are upgrading from Access 95 or Access 2, you will find this reference useful for finding new features and looking up new ways of getting a job done. If you are converting from other field data types--for example, dBASE, Paradox, or Btrieve--this Quick Reference might be the right amount of instruction you need to transfer your know-how investment to new products.

As a reference, this book is not intended to tutor learners. If you are just starting to use Access software for the first time, or are a very casual user, you might want to consider Que's User-Friendly Using Microsoft Access 97 or The Complete Idiot's Guide to Microsoft Access 97 as a book to get you up to speed. For beginner or very casual task reference, check out Que's Easy Microsoft Access 97. If you want the most complete reference as well as tutorial and foundation information, then you need Que's Special Edition Using Microsoft Access 97. This Microsoft Access 97 Quick Reference makes an ideal companion to the comprehensive Special Edition.

Click to Read More