GetDiffVersions Function

This function returns the names of the (workspace, savepoint) pairs on which the session has performed the SetDiffVersions Procedure operation.

Syntax

DBMS_WM.GetDiffVersions
RETURN VARCHAR2;

Usage Notes

The returned string is in the format '(WS1,SP1), (WS2,SP2)'. This format, including the parentheses, is intended to help you if you later want to use parts of the returned string in a call to the SetDiffVersions Procedure.

Examples

The following example displays the names of the (workspace, savepoint) pairs on which the session has performed the SetDiffVersions Procedure operation.

SELECT DBMS_WM.GetDiffVersions FROM DUAL;

GETDIFFVERSIONS                                                                 
--------------------------------------------------------------------------------
(B_focus_1, LATEST), (B_focus_2, LATEST)