GET_WORKSPACE Function

28.4 GET_WORKSPACE Function

This function exports the given workspace's definition and users. The optional p_with_% parameters (which all default to FALSE) can be used to include additional information in the export.

Syntax

APEX_EXPORT.GET_WORKSPACE (
    p_workspace_id          IN NUMBER,
    p_with_date             IN BOOLEAN  DEFAULT FALSE,
    p_with_team_development IN BOOLEAN  DEFAULT FALSE,
    p_with_misc             IN BOOLEAN  DEFAULT FALSE )
    RETURN apex_t_export_files;

Parameters

Parameters	Description
`p_workspace_id`	The workspace ID.
`p_with_date`	If `TRUE`, include export date and time in the result.
`p_with_team_development`	If `TRUE`, include team development data.
`p_with_misc`	If `TRUE`, include data from SQL Workshop, mail logs, and so on, in the export.

Returns

A table of apex_t_export_file.

Examples

The following example exports the definition of workspace #12345678.

DECLARE
    l_file apex_t_export_files;
BEGIN
    l_files := apex_export.get_workspace(p_workspace_id => 12345678);
END;

Parent topic: APEX_EXPORT