15.15 GET Functions
These functions retrieve column values. There is one function for each supported data type.
Syntax
FUNCTION GET_VARCHAR2 (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN VARCHAR2;
FUNCTION GET_NUMBER (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN NUMBER;
FUNCTION GET_DATE (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN DATE;
FUNCTION GET_TIMESTAMP (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP;
FUNCTION GET_TIMESTAMP_TZ (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH TIME ZONE;
FUNCTION GET_TIMESTAMP_LTZ (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH LOCAL TIME ZONE;
FUNCTION GET_CLOB (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN CLOB;
FUNCTION GET_INTERVALD2S (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN INTERVAL DAY TO SECOND;
FUNCTION GET_INTERVALY2M (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN INTERVAL YEAR TO MONTH;
Parameters
Table 15-13 GET Function Parameters
Parameter | Description |
---|---|
|
Context object obtained with one of the |
|
Column index. |
Returns
Column value as specific data type.
Parent topic: APEX_EXEC