2.1. Simplify SQL*Plus for Yourself on Windows
In this section we focus on methods that simplify SQL*Plus script file organization. You will eventually be creating, saving, and retrieving SQL*Plus scripts. You want the scripts to be separate from other files; you want to know exactly where they are and build and modify them without a lot of headaches.
SQL*Plus is a scripting language that includes command file support. This text encourages the use of command files, also called SQL scripts. Your SQL*Plus scripts will eventually contain multiple SQL DML statements, CREATE table statements with constraint clauses, and Oracle stored procedures and triggers written in PL/SQL.
When you install Oracle, whether it's the full enterprise licensed database ...