I, from time to time, get stuck in ‘ed‘ on SQL*Plus because the editor not defined like this:
SQL> select * from duall; select * from duall * ERROR at line 1: ORA-00942: table or view does not exist SQL> ed Wrote file afiedt.buf 22 ^C ? ^Z ?
The Ctrl-C and Ctrl-Z, wouldn’t get you out.
The solution is simple, type ‘q‘ and press ‘Enter‘, then set editor using ‘define_editor=vi‘ and try again 🙂 :
q 1* select * from duall SQL> define_editor=vi SQL> ed Wrote file afiedt.buf 1* select * from dual SQL> / D - X SQL>
If you found this blog post useful, please like as well as follow me through my various Social Media avenues available on the sidebar and/or subscribe to this oracle blog via WordPress/e-mail.
Zed DBA (Zahid Anwar)