Re: SQLPLUS training, why?

  • From: Rodd Holman <rodd.holman@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 28 Dec 2010 16:06:51 -0600

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: