Oracle - when i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 11 of 81

when i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?

Total Answers and Comments: 6

Last Update: February 16, 2009 Asked by: haisubbu

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 06, 2006 09:50:59

aruna9683@gmail.com

RE: when i type 'ed' or 'edit' in oracle i did n't pre...

Hi If you are using Oracle on Linux then you cannot use ed or edit command to edit statemets. -Aruna

Is this answer useful? Yes | No

March 22, 2006 13:40:25

Scott

RE: when i type 'ed' or 'edit' in oracle i did n't pre...

Can't use ed or edit to edit commands if you use Oracle on Linux?!?That's bull. All you have to do is define _editor; I use SQL*Plus on Linux all the time and edit works fine.

Is this answer useful? Yes | No

April 12, 2006 07:13:32

Asim Jamal

RE: when i type 'ed' or 'edit' in oracle i did n't pre...

If you are using Oracle in Unix or Linux make an entry in the

glogin.sql file for your default editor.

define_editor vi

You will find glogin.sql in OracleHome/sqlplus/admin directory.

Is this answer useful? Yes | No

April 25, 2007 05:29:14

dawood

RE: when i type 'ed' or 'edit' in oracle i did n't pre...

there are two way u can give:

1) sql> define_Editor 'Notepad';

2) go to menu editor editor-> define editor-> give the name that u want to appear i.e notepad or wordpad in the text box.

Is this answer useful? Yes | No

May 08, 2007 06:11:01

SMOKE

RE: when i type 'ed' or 'edit' in oracle i did n't pre...

For Linux or Unix.
SQL>define_editor vi;

Is this answer useful? Yes | No

February 16, 2009 01:58:41

nareshkumarmca

Member Since: February 2009 Contribution: 3

RE: when i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem?

In SQL prompt Type
define_editor vi in UNIX or
define_editor notepad in XP

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank