Sunday, August 8, 2010

using ed command

When trying to edit a sql query or a pl/sql program using ed command on linux platform, I end up with a probably primitive editor.
What I got is as:

SQL> ed
Wrote file afiedt.buf
29

?

The solution is to add follwing line to glogin.sql file of oracle user:

define_editor=vi