It's All About ORACLE

Oracle - The number one Database Management System. Hope this Blog will teach a lot about oracle.

SPOOL command



Syntax

SPO[OL] [file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]] | OFF | OUT]

CRE[ATE]
Creates a new file with the name specified.

REP[LACE]
Replaces the contents of an existing file. If the file does not exist, REPLACE creates the file. This is the default behavior.

APP[END]
Adds the contents of the buffer to the end of the file you specify.

OFF
Stops spooling.

OUT
Stops spooling and sends the file to your computer's standard (default) printer. This option is not available on some operating systems.

Enter SPOOL with no clauses to list the current spooling status.

To record your output in the new file DIARY using the default file extension, enter
SPOOL DIARY CREATE

To append your output to the existing file DIARY, enter
SPOOL DIARY APPEND

To record your output to the file DIARY, overwriting the existing content, enter
SPOOL DIARY REPLACE

To stop spooling and print the file on your default printer, enter
SPOOL OUT

0 comments:

You Might Also Like

Related Posts with Thumbnails

Pages