Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Fwd: Re: IDE for Oracle database]
you might try to add something like this:
SQL> set editfile "/tmp/buffer.sql"
this also solves the "problem" of all those afiedt.buf files in various places...
Kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Lyubomir Petrov
Sent: Sunday, July 04, 2004 09:53
To: oracle-l_at_freelists.org
Subject: Re: [Fwd: Re: IDE for Oracle database]
Hmmm, work fine for me...
SQL> define _editor=C:\Vim\vim62\gvim.exe SQL> 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:Received on Sun Jul 04 2004 - 03:55:24 CDT
>
>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
>-----------------------------------------------------------------
>
>.
>
>
>
---------------------------------------------------------------- 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 ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf ---------------------------------------------------------------- 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 -----------------------------------------------------------------