SQL*Plus User's Guide and Reference Release 8.1.5 A66736-01 |
|
Command Reference, 27 of 52
Executes a host operating system command without leaving SQL*Plus.
HO[ST] [command]
Refer to the following for a description of the term or clause:
Enter HOST without command to display an operating system prompt. You can then enter multiple operating system commands. For information on returning to SQL*Plus, refer to the Oracle installation and user's manual(s) provided for your operating system.
With some operating systems, you can use a "$" (VMS), "!" (UNIX), or another character instead of HOST. See the Oracle installation and user's manual(s) provided for your operating system for details.
You may not have access to the HOST command, depending on your operating system. See the Oracle installation and user's manual(s) provided for your operating system or ask your DBA for more information.
SQL*Plus removes the SQLTERMINATOR (a semicolon by default) before the HOST command is issued. A workaround for this is to add another SQLTERMINATOR. See the SQLTERMINATOR variable of the SET command in this chapter for more information on the SQLTERMINATOR.
To execute an operating system command, ls *.sql, enter
SQL> HOST ls *.sql
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|