Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The REDO command re-executes a statement that you entered earlier in your session. The statement is retrieved from the command log, which is a list of up to 256 statements that you have entered most recently during the current session. REDO enables you to changes in the statement before it is re-executed.
Note:
REDO statements themselves are not included in the command log; however, the statements re-executed by REDO are included.REDO [number|index] 'original' 'replacement' [specifier]
A positive INTEGER
that indicates the number of the statement to be re-executed. You can display the statements, with their numbers, using a RECAP statement.
A negative INTEGER
or 0
(zero) that indicates the position of the statement to be re-executed relative to the end of the command log. The most recent statement is 0
, the one before that is -1
, and so on. The default is 0
.
A text literal that is part of the statement to be re-executed.
A text literal that should replace original when the statement is re-executed.
A specifier listed in Table 10-2, "Valid Values for REDO specifier". Each specifier indicates where text replacement should occur in the re-executed statement.
Table 10-2 Valid Values for REDO specifier
Specifier | Meaning |
---|---|
|
Indicates that only the first occurrence of original should be changed to replacement. |
|
Indicates that only the last occurrence of original should be changed to replacement. |
n |
A number indicating which occurrence of original should be changed to replacement. For example, |
|
Indicates that all occurrences of original should be changed to replacement |
|
Indicates that all occurrences of original should be changed to replacement. |
The default is ALL. When you do not provide a specifier, all occurrences of original are changed to replacement.
When you type REDO without an argument, the most recent statement are re-executed.
When matching original with the text of the statement to be re-executed, REDO ignores case differences. For example, assume you specify AT
as original, REDO matches it with at
, At
, aT
, or AT
in the statement.
When replacing original with replacement, REDO retains the case of all characters in replacement. For example, assume you specify ShOw
as replacement, that is exactly how it appears in the re-executed statement.