Home » Other » 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

Report message to a moderator

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: 68641
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.]

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 2456
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

Report message to a moderator

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: 68641
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

Report message to a moderator

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: 2456
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

Report message to a moderator

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

Report message to a moderator

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: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
i didn`t get you

Report message to a moderator

Previous Topic: iSQL Plus formatting
Next Topic: Sql Developer connection with SqL server URGENT
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 12:24:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.