Oracle PL/SQL/SQL Plus/editor

Define editor

  

define _editor=vi
 -- or perhaps --
 define _editor=notepad
 clear buffer -- this command clears the contents of the SQL*Plus buffer
 edit

Define editor Notepad or vi

  
SQL>
SQL> set pause    "Enter... "
SQL> set pause    on
SQL> set numwidth 6
SQL> set pagesize 24
SQL> alter session set nls_date_format="dd-mm-yyyy";
Session altered.
SQL> -- define_editor=Notepad   /* for Windows */
SQL> -- define_editor=vi        /* for UNIX    */
SQL>