Syntax SPO[OL] [file_name[.ext] [CRE[ATE] |REP[LACE]| APP[END]] | OFF | OUT] Storesqueryresultsin a file, or optionally sends the file to a printer. Terms file_name[.ext] Represents the nameof the file to which you wish to spool. SPOOL followed byfile_namebegins spooling display...
Syntax SET ARRAY[SIZE]array_size Parameters SET ARRAY[SIZE] Is the command, which may be abbreviated SET ARRAY. array_size Is the number of rows fetched at one time. The default value is 15. The allowed range is from 1 to 5000. Increasing the array size allows SQL*Plus to return more...