Name

EDIT

Synopsis

ED[IT] [filename]

The EDIT command (not supported in iSQL*Plus) allows you to invoke an external editor to edit the contents of the SQL buffer or to edit the contents of an operating system file. For example:

EDIT
EDIT $ORACLE_BASE/admin/orcl/pfile/init.ora

The first command—with no parameter—allows you to edit the contents of the SQL buffer. The second allows you to edit a file.

You can specify the command that invokes the external editor via the _EDITOR user variable. Use the DEFINE command to change _EDITOR’s value.

Get Oracle SQL Plus Pocket Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.