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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
