|Oracle® OLAP DML Reference
10g Release 1 (10.1)
Part Number B10339-02
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.
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.
When you use both the search-text and the ALL or number arguments, you must specify search-text second.
When you specify RECAP without an argument, the ten most recent statements are provided.
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.
You can use the output of RECAP to edit a previously executed statement with REEDIT, or reexecute a previously executed statement with REDO.
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.
COMMAND LOG 3: dsc actual 5: report total(actual) 8: report average(actual)