15.20 GET Functions
This function retrieves column values for different data types.
Syntax
FUNCTION GET_VARCHAR2 (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN VARCHAR2;
FUNCTION GET_VARCHAR2 (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN VARCHAR2;
Signature 1
FUNCTION GET_NUMBER (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN NUMBER;
FUNCTION GET_NUMBER (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN NUMBER;
Signature 2
FUNCTION GET_DATE (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN DATE;
FUNCTION GET_DATE (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN DATE;
Signature 3
FUNCTION GET_TIMESTAMP (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP;
FUNCTION GET_TIMESTAMP (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN TIMESTAMP;
Signature 4
FUNCTION GET_TIMESTAMP_TZ (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH TIME ZONE;
FUNCTION GET_TIMESTAMP_TZ (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN TIMESTAMP WITH TIME ZONE;
Signature 5
FUNCTION GET_TIMESTAMP_LTZ (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN TIMESTAMP WITH LOCAL TIME ZONE;
FUNCTION GET_TIMESTAMP_LTZ (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN TIMESTAMP WITH LOCAL TIME ZONE;
Signature 6
FUNCTION GET_CLOB (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN CLOB;
FUNCTION GET_CLOB (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN CLOB;
Signature 7
FUNCTION GET_BLOB (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN BLOB;
FUNCTION GET_BLOB (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN BLOB;
Signature 8
FUNCTION GET_INTERVALD2S (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN DSINTERVAL_UNCONSTRAINED;
FUNCTION GET_INTERVALD2S (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN DSINTERVAL_UNCONSTRAINED;
Signature 9
FUNCTION GET_INTERVALY2M (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN YMINTERVAL_UNCONSTRAINED;
FUNCTION GET_INTERVALY2M (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN YMINTERVAL_UNCONSTRAINED;
Signature 10
FUNCTION GET_ANYDATA (
p_context IN t_context,
p_column_idx IN PLS_INTEGER ) RETURN SYS.ANYDATA;
FUNCTION GET_ANYDATA (
p_context IN t_context,
p_column_name IN VARCHAR2 ) RETURN SYS.ANYDATA;
Parameters
Table 15-18 GET Functions Parameters
Parameter | Description |
---|---|
|
Context object obtained with one of the OPEN_ functions. |
|
Column index. |
|
Column name. |
Returns
The column value as specific data type
Parent topic: APEX_EXEC