Oracle PL/SQL/SQL Plus/editor
Define editor
<source lang="sql">
define _editor=vi
-- or perhaps -- define _editor=notepad clear buffer -- this command clears the contents of the SQL*Plus buffer edit </source>
Define editor Notepad or vi
<source lang="sql">
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>
</source>