How to use the ed command of sqlplus to invoke the editor

This article introduces you how to use sqlplus ed command call editor, the content is very detailed, interested friends can refer to, hope to help you.

After Windows is installed, enter SQL> by default

EDITOR = "Notepad" SQL> define

DEFINE _DATE = "23-November-10" (CHAR)

DEFINE _CONNECT_IDENTIFIER = "win" (CHAR)

DEFINE _USER = "SYS" (CHAR)

DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)

DEFINE _SQLPLUS_RELEASE = "1002000100" (CHAR)

DEFINE _EDITOR = "Notepad" (CHAR)

DEFINE _O_VERSION = "Oracle Database 10g Enterprise

Edition Release 10.2.0.

1.0 - Production

With the Partitioning, OLAP and Data Mining options" (CHAR)

DEFINE _O_RELEASE = "1002000100" (CHAR)

DEFINE _RC = "1" (CHAR) and the default is_EDITOR = "ed" (CHAR) under Linux. Here we set the default editor to vi or vim [oracle@rhel5 admin]$ vi $ORACLE_HOME/sqlplus/admin/glogin.sql

Add DEFINE _EDITOR = "vi" or DEFINE _EDITOR = "vim" at the end of the file so we can call vi or vim editor when using sqlplus ed command.

About how to use sqlplus ed command call editor to share here, I hope the above content can have some help for everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.