2.6. Changes on the Command Line

The CHANGE command is very simple and often simpler and less time-consuming than using a mouse cut-and-paste. The actual command is CHANGE but can be abbreviated with the character “C.”

Any text editor change command requires a field terminator and, in this case, the terminating character is a forward slash—by default it is a forward slash but any character can be used, as we will illustrate. The CHANGE command syntax is:

C[HANGE]/old_text/new_text[/]

Use the following to just remove text:

C[HANGE]/old_text

In this and subsequent sections, a STUDENTS table is used to demonstrate SQL*Plus. A STUDENTS table can be created using the SQL provided in Chapter 1, Section 1.6, “Behind Tables.”

A helpful SQL*Plus command ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.