GotoDate Procedure

This procedure goes to a point at or near the specified date and time in the current workspace.

Syntax

DBMS_WM.GotoDate(
   in_date  IN DATE);

Parameters

Table 70-16 GotoDate Procedure Parameters  

Parameter	Description
in_date	Date and time for the read-only view of the workspace. (See the Usage Notes for details.)

Usage Notes

You are presented a read-only view of the current workspace at or near the specified date and time. The exact time point depends on the history option for tracking modifications, as set by the EnableVersioning Procedure or modified by the SetWoOverwriteOFF Procedure or SetWoOverwriteON Procedure:

• NONE: The read-only view reflects the first savepoint after in_date.

• VIEW_W_OVERWRITE: The read-only view contents can vary depending on when updates were performed and if or when savepoints were created. The view reflects the data values in effect at in_date except for rows that have been modified both (1) between in_date and the most recent savepoint before in_date and (2) between in_date and the next savepoint after in_date; for these rows the view reflects the date in effect at the most recent savepoint before in_date. Therefore, be careful if you use this procedure when the VIEW_W_OVERWRITE option is enabled.

• VIEW_WO_OVERWRITE: The read-only view reflects the data values in effect at in_date.

For an explanation of the history options, see the description of the hist parameter for the EnableVersioning Procedure. The following example scenario shows the effects of the VIEW_W_OVERWRITE and VIEW_WO_OVERWRITE settings. Assume the following sequence of events:

1. The MANAGER_NAME value in a row is Adams.

2. Savepoint SP1 is created.

3. The MANAGER_NAME value is changed to Baxter.

4. The time point that will be specified as in_date (in step 7) occurs.

5. The MANAGER_NAME value is changed to Chang. (Thus, the value has been changed both before and after in_date since the first savepoint and before the second savepoint.)

6. Savepoint SP2 is created.

7. A GotoDate Procedure operation is executed, specifying the time point in step 4 as in_date.

In the preceding scenario:

• If the history option in effect is VIEW_W_OVERWRITE, the MANAGER_NAME value after step 7 is Adams.

• If the history option in effect is VIEW_WO_OVERWRITE, the MANAGER_NAME value after step 7 is Baxter.

The GotoDate procedure should be executed while users exist in the workspace. There are no explicit privileges associated with this procedure.

Examples

The following example goes to a point at or near midnight at the start of 30-Jun-2000, depending on the history option currently in effect.

EXECUTE DBMS_WM.GotoDate ('30-JUN-00');