What does the DBMS_WM.GETWORKSPACE function return?

What does the DBMS_WM.GETWORKSPACE function return?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *