Hi,
I am new to Oracle and used most of the time sqldeveloper tool to query data, so just trying to learn some basic stuff.
I have oracle 10g box on Unix , and once i am connected to sqlplus prompt , i normally give command
ed and hit enter which open a vi editor where i can change the query. This works fine, no issues in that.
Now for practice purpose, i recently installed Virtual box 3.2.6 and installed OEL 5.0 on that , now after getting connected to sql prompt using oracle user , I typed a simple query like "select * from v$instance" which gave me the output as expected, and then I specified
ed on sql prompt and hit enter and instead of getting a option to edit the query in vi editor , it gave me this ... refer below
SQL> ed
Wrote file afiedt.buf
27
?
?
I am guessing it has something to do with
ed not really associated with vi editor .. can somebody guide me how can i fix this ??
I also checked in
oracle home dir, and found that there was a file with he name "afiedt.buf" present which had the very first query.
Let me know if any extra info is required for the same.
Regards
Learner