23.6 GET_TABLES_ARRAY Function

This function gets a list of table/view names matching regex criteria. If p_regex is null after trim, an empty array is returned.

Syntax

FUNCTION apex_db_dictionary.get_tables_array (
    p_regex          IN   VARCHAR2     DEFAULT NULL,
    p_owner          IN   VARCHAR2     DEFAULT NULL,
    p_object_type    IN   VARCHAR2     DEFAULT NULL )
    RETURN WWV_FLOW_T_VARCHAR2;

Parameters

Parameter	Description
p_regex	Regular expression for object names.
p_owner	Owner of the tables/views (default current user).
p_object_type	TABLE or VIEW. The default NULL returns tables and views.

Returns

This function returns an array of fully qualified names in the format OWNER.OBJECT_NAME.

Example 1

This example returns an array of names of tables and views matching the regular expression '^EMP_'.

declare
    l_tables apex_t_varchar2; 
begin 
    l_tables := apex_db_dictionary.get_tables_array( 
        p_regex => '^EMP_' ); 
end;

Example 2

This example returns an array of names of tables matching the regular expression '^DB_'.

declare
    l_tables apex_t_varchar2; 
begin 
    l_tables := apex_db_dictionary.get_tables_array( 
        p_regex       => '^DB_', 
        p_object_type => 'TABLE' ); 
end;