Browser-Based SQL*Plus

The new three- tier , web browser-based i SQL*Plus introduced in 2001 as part of Oracle9 i Database shook up the staid world of SQL*Plus, and certainly surprised many Oracle users (including me), who expected SQL*Plus to continue on as the simple, client-server application it always had been. Since then, Oracle has made virtually all of its administrative functionality web-accessible in the form of the newer , web-based Oracle Enterprise Manager interface in Oracle Database 10 g .

In Oracle9 i Database, i SQL*Plus ran under Oracle's HTTP Server, which was a version of the Apache web server connected to your Oracle database. In Oracle Database 10 g , i SQL*Plus runs as a Java 2 Enterprise Edition (J2EE) application server using Oracle Containers for Java (OC4J) as the server engine. In Oracle9 i Database, i SQL*Plus was installed separately from the database along with the HTTP Server. In Oracle Database 10 g , i SQL*Plus is installed by default with the database on the database server.

Using i SQL*Plus means that you can connect to your database from any machine on your network without the need to first install Oracle's client software. That's a real convenience, even for those of us who prefer the older, two-tier, command-line SQL*Plus.

     

Introduction to SQL*Plus

Command-Line SQL*Plus

Browser-Based SQL*Plus

A Lightning SQL Tutorial

Generating Reports with SQL*Plus

Creating HTML Reports

Advanced Reports

Writing SQL*Plus Scripts

Extracting and Loading Data

Exploring Your Database

Advanced Scripting

Tuning and Timing

The Product User Profile

Customizing Your SQL*Plus Environment

Appendix A. SQL*Plus Command Reference

Appendix B. SQL*Plus Format Elements



Oracle SQL Plus The Definitive Guide, 2nd Edition
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
ISBN: 0596007469
EAN: 2147483647
Year: N/A
Pages: 151

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net