Edit of linux oracle sqlplus

Edit of linux oracle sqlplus

SQL> editWrote file afiedt. buf120

 

As shown in the preceding figure when sqlplus starts to use the edit command, it is okay after I set vi to the Default Editor:

SQL> DEFINE _ EDITOR = vi

 

However, in this case, I only set session settings, which will expire after re-login. If you want to save the configuration, you can save the editor settings to the configuration file and use the configuration automatically each time. Modify the $ ORACLE_HOME/sqlplus/admin/glogin. SQL configuration file and add define _ editor = vi. When sqlplus is started, it will read the glogin. SQL script.