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 ?


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: 4426
Registered: April 1998
Senior Member

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.

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

Current Time: Wed Nov 25 17:48:50 CST 2015

Total time taken to generate the page: 0.07820 seconds