Re: SQLPLUS training, why?

Why use an external editor for this? Here is where knowing SQLPLUS commands is useful

SQL> l
Find the line number <n> of the code to change
SQL> l<n>
SQL> c/old_string/new_string
SQL> /
See new result here ;)

--Rodd

On 12/28/2010 07:24 AM, TESTAJ3@xxxxxxxxxxxxxx wrote:

:1,$ s/old_string/new_string/ <--- REs are your friend :)

joe

_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Other related posts: