GetMultiWorkspaces Function

This function returns the names of workspaces visible in the multiworkspace views for version-enabled tables.

Syntax

DBMS_WM.GetMultiWorkspaces
RETURN VARCHAR2;

Usage Notes

This procedure returns the names of workspaces visible in the multiworkspace views, which are described in Oracle9i Application Developer's Guide - Workspace Manager.

If no workspaces are visible in the multiworkspace views, NULL is returned. If more than one workspace name is returned, names are separated by a comma (for example: workspace1,workspace2,workspace3).

To make a workspace visible in the multiworkspace views, use the SetMultiWorkspaces Procedure.

Examples

The following example displays the names of workspaces visible in the multiworkspace views.

SELECT DBMS_WM.GetMultiWorkspaces FROM DUAL;