April 2000
Intermediate to advanced
94 pages
1h 52m
English
CHANGE
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
Is the text you want to change or delete.
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.