CHANGE text on the current line

From NazimWIKI
Jump to navigation Jump to search

A very basic feature of SQL *Plus which I had forgotten through the passage of time. Documented here so I don't forget again ..

You use this to change values on the current line of a SQL Statement in lieu of having to open up an editor.

c /oldvalue/newvalue

For example:

SQL> select first_name, last_name, employee_id from hr.employees where employee_id=100;

FIRST_NAME           LAST_NAME                 EMPLOYEE_ID
-------------------- ------------------------- -----------
Steven               King                              100

SQL> c /100/101
  1* select first_name, last_name, employee_id from hr.employees where employee_id=101
SQL> /

FIRST_NAME           LAST_NAME                 EMPLOYEE_ID
-------------------- ------------------------- -----------
Neena                Kochhar                           101