Oracle SQL*Plus Pocket Reference

Name

CHANGE

Synopsis

C[HANGE] /old_text[/[new_text[/]]

CHANGE is an editing command that allows you to do a search and replace on the current line in the SQL buffer. The CHANGE command is also used to delete text. For example:

SQL> l
  1* select dummy,smarty from duap
SQL> c /duap/dual/
  1* select dummy,smarty from dual
SQL> c /,smarty/
  1* select dummy from dual

Parameters

old_text

Is the text you want to change or delete.

new_text

Is the replacement text.

/

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 letter—and as long as it is used consistently throughout the command.