Re: Personal Oracle7 (SQL*Plus Editor)

In article <142_at_along.dialix.oz.au>, paladin_at_along.dialix.oz.au (Alex Long) says:
>
>
>In article <D7AMEC.8pB_at_westminster.ac.uk>, Mike Megan (mgyec_at_westminster.ac.uk) writes:
>>I'm having trouble getting the "EDIT" command to work with SQL*Plus
>>for *Windows* which came as part of the Personal Oracle7 package.
>>
>>I have tried using the following commands:
>>
>>DEFINE _EDITOR NOTEPAD
>>DEFINE _EDITOR NOTEPAD.EXE
>>DEFINE _EDITOR C:\WINDOWS\NOTEPAD.EXE
>>DEFINE _EDITOR C:\DOS\EDIT
>>...etc.
>>
>>None of these work.
>>
>>I would be grateful for any suggestions
>>Thanking you in advance,
>>
>>Michael Megan
>>mgyec_at_westminster.ac.uk
>
>Hi Michael,
>
>Pull down the Edit Menu option. There will be 2 options,
>one of the to invoke the editor, and the other to define it.
>
>Overwrite the NOTEPAD.EXE with your favourite Windows editor, in my
>example C:\ED4W\ED4W.EXE
>
>I don't know how to make that permanent though. So far, I have had
>to repeat this every time I invoke SQL*Plus.
>
>Regards,
>Alex Long
>

Have you tried putting the DEFINE _EDITOR command in you LOGIN.SQL file? This file will be executed whenever you start SQL*Plus. SQL*Plus looks in you current directory for the LOOGIN.SQL, but there is a SQLPLATH environment variable which can be defined to point to the directory you have your LOGIN.SQL. So you can start SQL*Plus where ever you are and SQL*Plus will find the LOGIN.SQL file. Received on Fri Apr 28 1995 - 00:00:00 CEST