Re: SQLPLUS training, why?

From: Don Seiler <don@xxxxxxxxx>
To: rodd.holman@xxxxxxxxx
Date: Tue, 28 Dec 2010 16:19:56 -0600

While that is useful if a better editor isn't available or configured, I'd
rather escape to vi/vim and just edit the whole thing quickly than going
one-line-at-a-time and doing search/replace statements.

Don.

On Tue, Dec 28, 2010 at 4:06 PM, Rodd Holman <rodd.holman@xxxxxxxxx> wrote:

>  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
>
>

-- 
Don Seiler
http://www.seiler.us

Follow-Ups:
- Re: SQLPLUS training, why?
  - From: Rodd Holman

References:
- SQLPLUS training, why?
  - From: Aragon, Gabriel (GE, Corporate, consultant)
- RE: SQLPLUS training, why?
  - From: TESTAJ3
- Re: SQLPLUS training, why?
  - From: Jared Still
- Re: SQLPLUS training, why?
  - From: coskan
- RE: SQLPLUS training, why?
  - From: Goulet, Richard
- RE: SQLPLUS training, why?
  - From: Taylor, Chris David
- RE: SQLPLUS training, why?
  - From: Jacques Kilchoer
- Re: SQLPLUS training, why?
  - From: Jared Still
- Re: SQLPLUS training, why?
  - From: Daniel W. Fink
- Re: SQLPLUS training, why?
  - From: Kellyn Pedersen
- RE: SQLPLUS training, why?
  - From: Taylor, Chris David
- RE: SQLPLUS training, why?
  - From: TESTAJ3
- Re: SQLPLUS training, why?
  - From: Rodd Holman

Re: SQLPLUS training, why?

Other related posts: