|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
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:
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>