OraFAQ Forum: Client Tools » How to change default editor in SQL *Plus (merged)

Home » Other » Client Tools » How to change default editor in SQL *Plus (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to change default editor in SQL *Plus (merged) [message #396852]

Wed, 08 April 2009 02:59

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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City

Senior Member

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

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

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

ramoradba
Messages: 2457
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

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

ramoradba
Messages: 2457
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

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

ramoradba
Messages: 2457
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 23:55:37 CST 2025