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.