Set Edit mode in sqlplus

Edit the SQL statement in the current SQLPLUS Buffer

For example, ed is short for editing the SQL statements in the buffer zone using the editor specified by our environment variables. Of course, it is the buffer zone of SQLPLUS. We can prove that, when we have no connected database, we can also use EDIT to EDIT it. If you want to modify the Default Editor, for example, change to vi

SQL> define _ EDITOR

DEFINE _ EDITOR = "ed" (CHAR)

SQL> define _ EDITOR = 'vi'

SQL> define _ EDITOR

DEFINE _ EDITOR = "vi" (CHAR)

Define _ EDITOR = 'vi' can be written in the sqlplus STARTUP configuration script. The STARTUP script is Oracle_home/sqlplus/admin/glogin. SQL. This script is automatically called when SQLPLUS is started, instead of when connecting to the database. After this script is run, the database will run the oracle_home/dbs/login. SQL script again. Therefore, if both scripts have the same description, login. SQL is the main one.