This module covers the techniques you can use to create, edit, and test SQL scripts within Oracle's SQL*Plus environment.
You have already seen the SQL*Plus environment in previous modules whenever you worked with a simulation.
Here you get to try out the features built into SQL*Plus that warrant the "Plus" in its name.
By the end of this module, you will know how to:
Describe SQL*Plus and identify when to use it
Change text by using the SQL*Plus text editor and run a query
Change a query by using a text editor
Save a query to a file, replace a file, edit a file
Modify column headings and display width in a column
Define the environment settings for SQL*Plus reports
Describe what gets saved in a file when using
The next lesson is an overview of the background and future development of the SQL*Plus programming environment.
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database installation.
It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.
There is also the SQL*Plus Instant Client which is a stand-alone command-line interface available on platforms that support the OCI Instant Client.
SQL*Plus Instant Client connects to any available Oracle database, but does not require its own Oracle database installation. See the Oracle Call Interface Programmer's Guide for more
information on the OCI Instant Client.
SQL*Plus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL, SQL*Plus and
operating system commands to perform the following:
- Format, perform calculations on, store, and print from query results
- Examine table and object definitions
- Develop and run batch scripts
- Perform database administration
You can use SQL*Plus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing
on the Internet. You can generate reports dynamically using the HTML output facility of SQL*Plus, or using the dynamic reporting capability of iSQL*Plus to run a script
from a web page.