|
|
 |
| |
Select is an exclusive member benefit of the IOUG. Click here to find out how to join. Click here to see other SELECT Journal issues
SELECT Journal
July 2001, Volume 8, No. 5

Features
- A SELECT Few
By Oracle's Ken Jacobs
This new feature gives you access to insight and information from the oracle community's VIPs. In this issue, we spend some time picking the brain of Oracle's Ken Jacobs.
- The New Oracle Disk Manager (ODM): Increased Manageability and Improved I/O Performance for Databases under Oracle9i
By Kevin Closson
A component of Oracle9i for managing database files, Oracle Disk Manager makes a DBA's job easier and improves system performance. This article discusses the benefits of ODM and features a performance benchmark study.
- Dynamic SQL
By Tom Kyte
This article is an extract from chapter 14 on Dynamic SQL in Tom Kyte’s forthcoming Wrox book Expert One-On-One Oracle. Normally, a program is developed with all of the SQL it uses hard coded into it. This is typically referred to as static SQL. Many useful programs, however, do not know what SQL they will be executing until run-time. It is SQL your program executes at run-time, which was not known at compile-time. Maybe your program generates queries on the fly based on user input; maybe it is a data load program you have developed. SQL*Plus is a great example of this sort of program, as is any ad-hoc query or reporting tool. SQL*Plus can execute and display the results of any SQL statement, and it definitely was not compiled knowing all of the SQL you would want to execute.
Regular Columns
Download Acrobat Reader
Copyright 2006 by the International Oracle Users Group
|
|
Contact Us | Download Acrobat Reader | Privacy Statement | Refund Policy
Copyright and Disclaimer | Discussion Forum Access | Secured Area Access Agreement
IOUG Headquarters • 401 N. Michigan Ave., 22nd Floor • Chicago, IL 60611 • (312) 245-1579 • ioug@ioug.org
Copyright 2000 - 2006 by the Independent Oracle Users Group
|
|