How to exit out of ed in sql
When you try to edit using ed
SQL> ed
Wrote file afiedt.buf
35
q
1* select count(*) from dba_objects
SQL>
Solution :
type ‘ q ‘ and enter
Even sometime if you type q and enter, not working
SQL> ed
Wrote file afiedt.buf
35
;djg;fg;
?
p
/
p
/
i
k
l
m
q
nm
n;
Solution
ctrl + D
Use editor vi
SQL> define_editor=vi
SQL> ed
Wrote file afiedt.buf
1* select count(*) from dba_objects where owner=’APPS’
SQL> /
COUNT(*)
———-
183940
DBA 