Home » Developer & Programmer » Designer » Not able to edit in sql prompt
Not able to edit in sql prompt [message #90778] Mon, 22 November 2004 18:19 Go to next message
Anoop Rawat
Messages: 6
Registered: November 2004
Junior Member
 

Hi Guys

Recently i have installed Oracle 8i on Sun solaris and i have also created Database . But after starting Database , when i logged in and do  ed in sql prompt i.e

SQL>ed 1.sql

file 1.sql does not getting editted.

can anybody help me why i am getting this error ?

Regards

Anoop Rawat

Email id akrawat@rediffmail.com

Report message to a moderator

Re: Not able to edit in sql prompt [message #90780 is a reply to message #90778] Tue, 23 November 2004 03:30 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Hi,

You need to define an editor:

SQL> DEFINE _editor="vi"


BTW: If you add this command to your login.sql or glogin.sql file, it will be executed every time you start SQL*Plus.

Best regards.

Frank

Report message to a moderator

Previous Topic: How to calculate a row size of table
Next Topic: ORACLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 00:37:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.