26.10 GET_SCHEMAS Function
The GET_SCHEMAS
function retrieves a comma-delimited list of schemas that are mapped to a given workspace.
Syntax
APEX_INSTANCE_ADMIN.GET_SCHEMAS(
p_workspace IN VARCHAR2)
RETURN VARCHAR2;
Parameters
Table 26-6 GET_SCHEMAS Parameters
Parameter | Description |
---|---|
|
The name of the workspace from which to retrieve the schema list. |
Example
The following example demonstrates how to use the GET_SCHEMA
function to retrieve the underlying schemas mapped to a workspace.
DECLARE
L_VAL VARCHAR2(4000);
BEGIN
L_VAL :=APEX_INSTANCE_ADMIN.GET_SCHEMAS('MY_WORKSPACE');
DBMS_OUTPUT.PUT_LINE('The schemas for my workspace: '||L_VAL);
END;
Parent topic: APEX_INSTANCE_ADMIN