Re: Editor of SQLplus
From: Chris Leonard <s_p_a_m_chris_at_hotmail.com>
Date: Wed, 18 Dec 2002 15:16:24 -0600
Message-ID: <JA5M9.40$HE3.101585_at_news.uswest.net>
Date: Wed, 18 Dec 2002 15:16:24 -0600
Message-ID: <JA5M9.40$HE3.101585_at_news.uswest.net>
FYI, the SQLPATH environment variable defines a group of folders in which SQL*Plus will look for scripts. IE., if I run _at_myscript.sql and myscript.sql is located on the SQLPATH, then SQL*Plus will find it. Otherwise, I have to enter _at_c:\full\path\myscript.sql (or /u00/app/oracle/scripts/myscript.sql). SQLPATH is very useful, but I just wanted to point out that the use of the SQLPATH is not necessary to set the editor. You just use the def command (as mentioned in my other post).
-- Cheers, Chris ___________________________________ Chris Leonard, The Database Guy http://www.databaseguy.com Brainbench MVP for Oracle Admin http://www.brainbench.com MCSE, MCDBA, MCT, OCP, CIW ___________________________________ "Bill Reynolds" <bill_reynolds_at_hotmail.com> wrote in message news:27439ec3.0212171221.50913fba_at_posting.google.com...Received on Wed Dec 18 2002 - 22:16:24 CET
> akoutoulakis_at_hotmail.com (arisk) wrote in message
news:<e90dfa8d.0212170729.392c05fd_at_posting.google.com>...
> > How to change the default editor of SQLplus ? For example i want to
> > change the default editor notepad to the wordpad.
> > thank you
>
> I'll assume you're using NT, since you did not specify an OS. Here is
> how I do it on this godforsaken platform:
>
> Define an environment variable called SQLPATH, and point it to a
> directory on your machine. Add this line to your AUTOEXEC.BAT file:
>
> set SQLPATH=C:\docs\sql
>
> You can also set the variable by right-clicking on My Computer, select
> Properties, click Advanced, click Environment Variables, click New
> under System Variables, and entering the above info for Variable Name
> and Variable Value. Easy, eh?
>
> Drop a file in that directory called 'login.sql'. Add a line like the
> following:
>
> define_editor = c:\winnt\system32\write
>
> to target wordpad.
>
> Incidentally, you can add other sqlplus customizations to that file as
> well, so you can have lines like
>
> set pagesize 100
>
> to bump the default pagesize from 25 to 100.
>
> This also works under UNIX - just define SQLPATH in your environment
> and you're set.
>
> HTH
>
> -Bill