RE: [Fwd: Re: IDE for Oracle database]

From: GBA_DBA <galo.balda_at_gye.on.net.ec>
Date: Sun, 4 Jul 2004 19:58:47 -0500
Message-Id: <200407050035.i650ZrF10008@netrax2.easynet.net.ec>

I'm working with Windows XP pro.

SQL*Plus: Release 9.2.0.1.0 - Production on Dom Jul 4 19:48:26 2004

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, Oracle Label Security, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

galo_at_ORACLE9I> select 'AAA' from dual;

'AA

---
AAA

galo_at_ORACLE9I> ed
Wrote file afiedt.buf

  1* select 'AAA' from dual
galo_at_ORACLE9I> /

'AA
---
AAA

galo_at_ORACLE9I> get afiedt.buf
  1* select 'BBB' from dual
galo_at_ORACLE9I> /

'BB
---
BBB

galo_at_ORACLE9I> 

Regards
GBA

-----Mensaje original-----
De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En
nombre de Lyubomir Petrov
Enviado el: Domingo, 04 de Julio de 2004 03:53
Para: oracle-l_at_freelists.org
Asunto: Re: [Fwd: Re: IDE for Oracle database]

Hmmm, work fine for me...

SQL> define _editor=C:\Vim\vim62\gvim.exe select 'AAA' from dual;

'AA
---
AAA

SQL> ed
Wrote file afiedt.buf

  1* select 'BBB' from dual
SQL> /

'BB
---
BBB

SQL>

This was tested in both sqlplus and sqlplusw, Release 10.1.0.2.0 (Oracle
Client installed on Windows XP Professional).

Can you post more details about the client that you are using? Any details
about the test?

Regards,
Lyubomir Petrov


GBA_DBA wrote:



> 

>Notes in-line.

>

>Regards

>GBA

>

>-----Mensaje original-----

>De: oracle-l-bounce_at_freelists.org 

>[mailto:oracle-l-bounce_at_freelists.org] En nombre de Lyubomir Petrov 

>Enviado el: Viernes, 02 de Julio de 2004 23:21

>Para: oracle-l_at_freelists.org

>Asunto: Re: [Fwd: Re: IDE for Oracle database]

>

>GBA,

>

>1) Install gvim for windows.

><GBA> Done.

>2) Then in sql*plus:

>    define _editor=<path to gvim>

>3) You can put the command from 2) in the glogin.sql file 

>(%ORACLE_HOME%\sqlplus\admin\glogin.sql), so you do not have to write 

>this every time you start sql*plus.

><GBA> Done.

><GBA> The only problem i have is when i finish a query i type :wq to 

>get back to sql*plus <GBA> if I do press / an then ENTER, sql*plus 

>executes the first query i had in memory,  <GBA> not the one i 

>modified. I have to type get afiedt.buf and then / + ENTER to execute 

><GBA> the modified query. How can i do to make it work just like with 

>notepad??

>

>Regards,

>Lyubomir Petrov

>

>

>GBA_DBA wrote:

>

>  

>

>>How do you configure Vim to work with sql*plus on windows??

>>

>>Regards

>>GBA

>>

>> 

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Sun Jul 04 2004 - 19:56:32 CDT