|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
get [file] file-name [list|nolist]
Loads the file named file-name.suffix into the SQL*Plus buffer.
The suffix is .sql unless it has been specified with set suffix.
The buffer can be saved with save.
The get command won't work if the restriction level is set to at least 3:
C:>sqlplus -r 3 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> get foo SP2-0738: Restricted command "get" not available RENE>