SQL*Plus File Commands

• SAV[E] filename [.ext] [REP[LACE] APP[END]] : Saves current contents of SQL buffer to a file. User APPEND to add an existing file; use REPLACE to overwrite an existing file. The default extension is .sql.
  
  
• GET filename [.ext] : Writes the contents of a previously saved file to the SQL buffer. The default extension for the file name is .sql
  
  
• STA[RT] filename [.ext] : Runs a previously saved command file
  
  
• @filename : Runs a previously saved command file (same as start)
  
  
• ED[IT] :  Invokes the editor and saved the buffer contents to a file named afiedt.buf
  
  
• SPO[OL] [filename[.ext] | OFF|OUT] : Stores query result in a file. OFF closes the spool file. OUT closes the spool file and sends the file results to the printer.
  
  
• EXIT : Quits SQL*Plus