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
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: 4579
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
Previous Topic: How to calculate a row size of table
Next Topic: ORACLE
Goto Forum:
  


Current Time: Thu Mar 28 03:12:38 CDT 2024