Home » SQL & PL/SQL » Client Tools » How to change default editor in SQL *Plus (merged)
How to change default editor in SQL *Plus (merged) [message #396852] Wed, 08 April 2009 02:59 Go to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi all,

While I give "ed" command on sql prompt, it opens notepad by default.
Now if want to change that behaviour of SQL *Plus, is it possible?
I mean, I want to open wordpad or other third party editor.
If possible, please tell me.

regards,
Delna
Re: How to change default editor in SQL *Plus [message #396856 is a reply to message #396852] Wed, 08 April 2009 03:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> def
...
DEFINE _EDITOR         = "Notepad" (CHAR)
...

Regards
Michel

[OT: instead of changing your nickname each week, you should change your avatar.]

How to change default editor in SQL *Plus [message #396863 is a reply to message #396852] Wed, 08 April 2009 03:36 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hi all,

While I give "ed" command on sql prompt, it opens notepad by default.
Now if want to change that behaviour of SQL *Plus, is it possible?
I mean, I want to open wordpad or other third party editor.
If possible, please tell me.

regards,
Delna
Re: How to change default editor in SQL *Plus [message #396865 is a reply to message #396863] Wed, 08 April 2009 03:40 Go to previous messageGo to next message
bonker
Messages: 402
Registered: July 2005
Senior Member
Why multipost? Your last post has been moved to Client tools section by the forum adminstrators and Michael has posted his reply there.

[Updated on: Wed, 08 April 2009 03:41]

Report message to a moderator

Re: How to change default editor in SQL *Plus [message #396871 is a reply to message #396856] Wed, 08 April 2009 04:19 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Hello Michel sir,

when I run following command,
SQL>define _editor = "wordpad"
SQL>ed
Wrote file afiedt.buf

  1  begin
  2     if(to_char(sysdate,'hh24') < 12 ) then
  3             dbms_output.put_line('Hi ' || user || '! Good Morning...');
  4     elsif(to_char(sysdate, 'hh24') < 17) then


It does not show any editor. It simply prints previous executed block.
So what to do?
And I did not get
Quote:

[OT: instead of changing your nickname each week, you should change your avatar.]



regards,
Delna
Re: How to change default editor in SQL *Plus [message #396876 is a reply to message #396871] Wed, 08 April 2009 04:42 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
NOt sure but try this.....
http://www.windowsnetworking.com/kbase/WindowsTips/WindowsNT/RegistryTips/Restriction/Changebatchfilesdefaulteditor.html


Regards
Sriram
Re: How to change default editor in SQL *Plus [message #396877 is a reply to message #396871] Wed, 08 April 2009 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does wordpad in your default path? I bet not; in this case, you just see a DOS window pops up with
'wordpad' is not recognized as an internal or external command,
operable program or batch file.
and close immediatly.
And when you close the editor, SQL*Plus automatically list its content.
So put the full path for wordpad and it will work.

Quote:
[OT: instead of changing your nickname each week, you should change your avatar.]

I confused with deb.b which also hijacks a star picture.

Regards
Michel

[Updated on: Wed, 08 April 2009 04:47]

Report message to a moderator

Re: How to change default editor in SQL *Plus [message #396884 is a reply to message #396877] Wed, 08 April 2009 05:09 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Thank you Michel sir.
It works now Smile

And thanks for that comment also, As it is my original avatar. Cool

regards,
Delna
Re: How to change default editor in SQL *Plus [message #396885 is a reply to message #396877] Wed, 08 April 2009 05:12 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
yes Michel you are right ...
the link posted by me is exactly saying that.

And in some more content like how to change the entry values based on user interest.

Thanks & regards
Sriram
Re: How to change default editor in SQL *Plus [message #396938 is a reply to message #396885] Wed, 08 April 2009 07:35 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
Whatever you think or say, Fact will remain fact and wont change.

regards,
Delna
Re: How to change default editor in SQL *Plus [message #396961 is a reply to message #396938] Wed, 08 April 2009 08:52 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
i didn`t get you
Previous Topic: iSQL Plus formatting
Next Topic: Sql Developer connection with SqL server URGENT
Goto Forum:
  


Current Time: Thu Dec 08 10:04:32 CST 2016

Total time taken to generate the page: 2.95917 seconds