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>