Using DataDirect Connect for ADO.NET with Oracle Real Application Clusters (RAC)
Oracle RAC, as implemented in Oracle 9i and Oracle 10g, allows a single physical Oracle database to be accessed by concurrent instances of Oracle running across different CPUs. This document explains how the DataDirect Connect for ADO.NET Oracle data provider can connect to an Oracle RAC system as if it was a single instance of an Oracle database. The data provider can use a connection string or retrieve specific connection information from a tnsnames.ora fi
Read more
Introduction to ADO.NET and Databases
A DATABASE is an organized collection of information that is divided into tables. Each table is further divided into rows and columns; these columns store the actual information. You access a database using Structured Query Language (SQL), which is a standard language supported by most database software including SQL Server, Access, and Oracle.
Read more
Oracle Discoverer EUL Command Line for Java
OracleAS Discoverer is Oracle’s award winning, easy-to-use ad-hoc query, reporting and Web publishing tool. There are two aspects to any Discoverer system:
• Creating and maintaining an End User Layer (EUL)
• Generating ad-hoc queries, reports and publishing data
Read more
Introduction to Structured Query Language
This page is a introductory tutorial of the Structured Query Language (also known as SQL) and is a pioneering effort on the World Wide Web, as this is the first comprehensive SQL tutorial available on the Internet. SQL allows users to access data in relational database management systems, such as Oracle, Sybase, Informix, Microsoft SQL Server, Access, and others, by allowing users to describe the data the user wishes to see. SQL also allows users to define the data in a database, and manipulate that data. This page will describe how to use SQL, and give examples. The SQL used in this document is “ANSI”, or standard SQL, and no SQL features of specific database management systems will be discussed until the “Nonstandard SQL” section. It is recommended that you print this page, so that you can easily refer back to previous examples.
Read more
Structured Query Language (SQL) Tutorial
Many database applications, such as Access LCTA, offer analyses and utilities to summarize data. In order to summarize data beyond these programs and maintain the database, Structured Query Language (SQL) is required. Although many databases allow for generating queries through the use of a point-and-click tool, this is often time consuming. Once the basic SQL statements are understood, summarizing and maintaining the data will become easier and faster.
Read more