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>