Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Good editing environment....?
Kenn Herman wrote:
>
> The way I have been editting procedures is to have a scratch window to
> write my procedure in including the "create or replace" and the
> trailing "/". Once I am ready, I paste it into the sqlplus command line.
> well once there I can edit it with the editor of my choice, but as soon as
> I make any other SQL args then the buffer is lost. I have to then "select
> text from user_source where name = 'PROCEDURE_NAME';" to retrieve it and
> the paste it back to my scratch window.
>
> I am _sure_ there has to be a better way then this but have seen no
> reference to it.
A good editing environment, hmmm... Well, on Windows I use Wordpad.
The
procedure is something like this:
Not fancy, but it works for me.
P.S I even have a similar method when I am on the VAX. I just have to open two terminal sessions, one for EDT and one for SQL*Plus.
-- Tomm Carr -- "Can you describe your assailant?" "No problem, Officer. That's exactly what I was doing when he hit me!"Received on Fri Jul 18 1997 - 00:00:00 CDT