This Oracle Tutorial is visited quite frequently by visitors looking for answers about Oracle and the Oracle Tools.
So I thought, it might be a good idea, to give you a forum, where you can ask questions and hopefully get answers beyond this tutorial.
The forum just opened, please visit and participate, so we all benefit from your questions and solutions.
I will try to moderate as much as possible until we have found some volunteers, that are interested in taking over this task.
The Oracle Relational Database Management System (RDBMS) is an
industry leading database system designed for mission critical data
storage and retrieval. The RDBMS is responsible for accurately
storing data and efficiently retrieving that data in response to
user queries.
The Oracle Corporation also supplies interface tools to access
data stored in an Oracle database. Two of these tools are known as
SQL*Plus, a command line interface, and Developer 9i (now called
simply Developer), a collection
of forms, reports and graphics interfaces.
This technical working paper introduces the features of
the SQL*Plus tool and provides a tutorial that demonstrates
its salient features.
This document is organized as follows. A brief overview of
the suite of Oracle products is first presented in Section
2.
In Section 3, we discuss the
basics of working with the SQL*Plus tool.
Structured Query Language (SQL), including
data definition language (DDL) and data
manipulation language (DML) is discussed in
section 4. Advanced
SQL*Plus commands are discussed in section
5
and a brief introduction to stored procedures
and triggers is given in section
6.
2. Oracle Products: An Overview
The Oracle products suite includes the following tools and utilities:
2.1 Application Development Tools
SQL*Plus - A command line tool used to manipulate
tables and other database objects in an Oracle database.
Developer 9i - A suite of application development tools including Forms, Reports and Graphics.
Oracle*Forms - A screen based tool used to develop data
entry forms and menus that access tables in an Oracle database.
Oracle*Reports - A screen based tool used to develop
reports that access tables in an Oracle database.
Oracle*Graphics - A graphical tool used to develop
charts and reports that access tables in an Oracle database.
CASE*Designer and Oracle Designer 9i -
A graphical tool used to create and display models
contained in the CASE*Dictionary.
