René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

edit [SQL*Plus]

SQL> edit
SQL> ed

SQL> edit sql_script_file
SQL> ed sql_script_file
With edit (or ed for short), it is possible to edit the most recently entered SQL command in SQL*Plus.
If edit is followed by a file name, it edits (or creates) this file.
SQL*Plus chooses the editor that was defined through the _editor variable. That is, if you want to start pfe.exe with edit, define _editor like so:
define _editor=pfe.exe

Restriction level

The edit command won't work if the restriction level is set to at least 1:
C:>sqlplus -r 1 rene/rene

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 17 21:10:39 2006

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

RENE> edit
SP2-0738: Restricted command "edit" not available
RENE>