Name
CHANGE â Not available in iSQL*Plus
Synopsis
CHANGE, an editing command, allows you to search and replace on a line in the SQL buffer. The CHANGE command also deletes text.
Syntax
C[HANGE] /old_text[/[new_text[/]]
Parameters
- C[HANGE]
Is the command, which may be abbreviated C.
- old_text
Is the text you want to change or delete.
- new_text
Is the replacement text.
- /
The forward slash character is commonly used to delimit the old and new text strings, but any other character may be used as long as it is not a number or a letter, and as long as it is used consistently throughout the command.
CHANGE and all the other editing commands are described in Chapter 2.
Get Oracle SQL*Plus: The Definitive Guide, 2nd 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.
