CHANGE text on the current line
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