SQL Plus - Edit Command

Card Puncher Data Processing

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.

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)

How to

open a file

ed D:\svn_sql\login.sql

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

open the buffer

ed 





Discover More
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Editor

The dynamic substitution variable _EDITOR gives the current editor You use it in conjunction with the edit function. You must define it in an startup script



Share this page:
Follow us:
Task Runner