Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


The RECAP command sends statements that were previously entered during the current session to the current outfile or to a file that you specify. The statements are copied from the command log, which is a list of up to 256 of the most recently entered statements.


RECAP [number|ALL] [ 'search-text' ] [ FILE file-id ]



A positive integer that indicates the number of statements to be provided. When you specify search-text, RECAP provides this number of statements from the subset that contains the search-text string. When you do not specify search-text, RECAP provides this number of statements from the most recently executed portion of the command log. The default number is 10.


When you specify search-text, ALL requests every statement that meets the search requirements. When you do not specify search-text, ALL requests every statement in the command log.


A quoted text literal. When you specify this argument, RECAP searches the statements in the command log for the ones that contain search-text. The search is not case-sensitive. These statements will then compose the subset from which RECAP provides number or ALL statements.

FILE file-id

Writes the output of the RECAP command to the specified file. The file-id is a text expression that represents the name of the file. The name must be in a standard format for a file identifier.


Order of search-text Argument

When you use both the search-text and the ALL or number arguments, you must specify search-text second.

RECAP with No Argument

When you specify RECAP without an argument, the ten most recent statements are provided.

Command Log

The command log is a list maintained internally by Oracle OLAP. It contains the statements that were executed most recently in your session. The maximum number of statements in the command log is 256. When you start a new session, the list is empty.

Re-Executing Statements

You can use the output of RECAP to edit a previously executed statement with REEDIT, or reexecute a previously executed statement with REDO.

Statements Not in Command Log

RECAP, REDO, and REEDIT commands are not included in the command log. But the statements re-executed by REDO and re-edited by REEDIT are included.

Identifying Files and Directories

When specifying files and directories in OLAP DML statements, it is good practice to always enclose them in single quotes.


Example 20-4 Obtaining the Last Three Statements Containing "actual"

The following RECAP command requests the three most recent statements that included the text literal "actual."

RECAP 3 'actual'

This statement could produce the following output.

    3: dsc actual
    5: report total(actual)
    8: report average(actual)