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
morad_dba
Messages: 70
Registered: June 2008
Member

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 ?

Regards,
Morad.
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: 1948
Registered: January 2010
Senior Member
In SQL*Plus issue

define _editor


and check output. For example:

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


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%.

SY.

[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: Tue Jul 22 15:25:18 CDT 2014

Total time taken to generate the page: 0.11076 seconds