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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset