Oracle PL/SQL/SQL Plus/editor

Материал из SQL эксперт
Перейти к: навигация, поиск

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>