CHANGE text on the current line

From NazimWIKI
Revision as of 21:56, 8 November 2019 by Admin (talk | contribs) (Created page with "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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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