Home » SQL & PL/SQL » Client Tools » Not getting Editor from sqlplus* (Windows 7 and oracle 10g)
Not getting Editor from sqlplus* [message #541185] Sun, 29 January 2012 04:45 Go to next message
Messages: 93
Registered: June 2008

Dear all,

I am using Windows 7 and oracle 10g; From sqlplus* I can not use editor (using ed).

but when I see the variable from DEFINE.. It shows that default editor is notepad..

Note: I can use editor in winxp.

Pls tell me... How to get (use) editor ?

Re: Not getting Editor from sqlplus* [message #541189 is a reply to message #541185] Sun, 29 January 2012 06:57 Go to previous message
Solomon Yakobson
Messages: 2812
Registered: January 2010
Location: Connecticut, USA
Senior Member
In SQL*Plus issue

define _editor

and check output. For example:

SQL> define _editor
DEFINE _EDITOR         = "Notepad" (CHAR)

Then in command window or using sqlplus HOST command try starting editor that shows us in define _editor output:

host notepad

If editor window doesn't appear make sure editor is on the %PATH%.


[Updated on: Sun, 29 January 2012 07:00]

Report message to a moderator

Previous Topic: Unable to Print The Query Output On TOAD
Next Topic: REF CURSOR to print output from given input
Goto Forum:

Current Time: Wed Nov 14 07:24:59 CST 2018