Sql*Plus integration

[Eike Heinze]

Hi;
I need to use Oracle's Sql*Plus a lot, a real lot!

I would like to get my Sql statement directly into Textpad and after leaving Textpad
have the edited Sql statement back in Sql*Plus' statement buffer...

I works with standard MS Notepad - grrrr!
Endless praises to the one who puts me on the track!

TIA
Eike

[Frank Fesevur]

Hi,

Simply install the txplink that you can find on the add-on pages to replace the notepad.exe

Regards,
Frank

[Rob Hale]

I love Textpad, but if you are doing Oracle development you should look into using TOAD instead of Sql*Plus. You can get a free version of it at http://www.toadsoft.com.

Regards,
Rob

[Pat J]

If you use Oracle SQL*Plus, you can configure to your installation to use a different editor. It's been a while since I worked on SQL Plus but if I remember right, sp allows you to "browse" for a new editor and all you have to do is point to Textpad.exe at that point....look under options.

[Zsolt Horváth]

In the <ORACLE_HOME>\Plus33\glogin.sql file you need write the next line:
define _editor="c:\Program Files\TextPad 4\TextPad.exe"

good luck
ZSolt

[Zsolt Horváth]

In the <ORACLE_HOME>\Plus33\glogin.sql file you need to write the next line:
define _editor="c:\Program Files\TextPad 4\TextPad.exe"

good luck
ZSolt