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

  • From: "GBA_DBA" <galo.balda@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Sun, 4 Jul 2004 19:58:47 -0500

 
I'm working with Windows XP pro.

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

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


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@ORACLE9I> select 'AAA' from dual;

'AA
---
AAA

galo@ORACLE9I> ed
Wrote file afiedt.buf

  1* select 'AAA' from dual
galo@ORACLE9I> /

'AA
---
AAA

galo@ORACLE9I> get afiedt.buf
  1* select 'BBB' from dual
galo@ORACLE9I> /

'BB
---
BBB

galo@ORACLE9I> 

Regards
GBA

-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de Lyubomir Petrov
Enviado el: Domingo, 04 de Julio de 2004 03:53
Para: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx 
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] En nombre de Lyubomir Petrov 
>Enviado el: Viernes, 02 de Julio de 2004 23:21
>Para: oracle-l@xxxxxxxxxxxxx
>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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: