SQL Plus - Edit Command

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

The edit command invokes an operating system text editor on the contents of:

  • the specified file
  • or on the contents of the SQL buffer.
Advertising

3 - Syntax

ED[IT] [file_name[.ext]]

where:

  • file name is the name of a file without extension. (Default the current SQL buffer, when you exit the editor, the changed SQL buffer is returned to SQL*Plus)
  • ext is the file extension (default sql)

4 - How to

4.1 - open a file

ed D:\svn_sql\login.sql

to open the file D:\svn_sql\login.sql

4.2 - open the buffer

ed