GET_SCHEMAS Function

The GET_SCHEMAS function retrieves a list of schemas that are mapped to a given workspace.

Syntax

APEX_INSTANCE_ADMIN.GET_SCHEMAS(
    p_workspace     IN VARCHAR2)
RETURN VARCHAR2;

Parameters

Table: GET_SCHEMAS Parameters describes the parameters available in the GET_SCHEMAS function.

GET_SCHEMAS Parameters

Parameter	Description
`p_workspace`	The name of the workspace from which to retrieve the schema list.

Example

DECLARE 
    L_VAL VARCHAR2(4000);
BEGIN
    L_VAL := 
APEX_INSTANCE_ADMIN.GET_SCHEMAS('MY_WORKSPACE');
    HTP.P('The schemas for my workspace: '||L_VAL);
END;