DESCRIBE_QUERY Function Signature 1

27.15 DESCRIBE_QUERY Function Signature 1

This procedure describes the query context based on the current region source.

Syntax

APEX_EXEC.DESCRIBE_QUERY (
    p_columns                IN t_columns          DEFAULT c_empty_columns )
    RETURN t_columns;

Parameters

Parameter	Description
`p_columns`	Columns to be selected from the data source.

Returns

The t_columns object describing the columns and data types.

Example

The following example describes a query and prints out result column names.

DECLARE
    l_columns apex_exec.t_columns;
BEGIN
    l_columns := apex_exec.describe_query;

    FOR i in 1 .. l_columns.count LOOP
        htp.p( 'Column #' || i || ': ' || apex_escape.html( l_columns( i ).name ));
    END LOOP;
END;

Parent topic: APEX_EXEC