What does the DBMS_WM.GETWORKSPACE function return?
A.
the name of your current workspace
B.
a comma-delimited list of all the workspaces in the database.
C.
a comma-delimited list of all the users assigned to the current workspace
D.
a comma-delimited list of all the workspaces to which you have been assigned
Explanation:
GetWorkspace
Returns the current workspace for the session.
Format
DBMS_WM.GetWorkspace() RETURN VARCHAR2;
Parameters
None.
Usage Notes
None.
Examples
The following example displays the current workspace for the session.
SELECT DBMS_WM.GetWorkspace FROM DUAL;
GETWORKSPACE
B_focus_2
REF.: Oracle(r) 10g Application Developer’s Guide – Workspace Manager, 4-69