The following constants are used in APEX_EXEC
package.
INTERNAL constants - DO NOT USE
c_location_local_db constant t_location := 'LOCAL'; c_location_remote_db constant t_location := 'REMOTE'; c_location_web_source constant t_location := 'WEB_SOURCE'; c_lov_shared constant t_lov_type := 1; c_lov_sql_query constant t_lov_type := 2; c_lov_static constant t_lov_type := 3; subtype t_query_type is varchar2(23); c_query_type_table constant t_query_type := 'TABLE'; c_query_type_sql_query constant t_query_type := 'SQL'; c_query_type_func_return_sql constant t_query_type := 'FUNC_BODY_RETURNING_SQL'; subtype t_dml_operation is pls_integer range 1..3; c_dml_operation_insert constant t_dml_operation := 1; c_dml_operation_update constant t_dml_operation := 2; c_dml_operation_delete constant t_dml_operation := 3; subtype t_target_type is varchar2(5); c_target_type_table constant t_target_type := 'TABLE'; c_target_type_sql_query constant t_target_type := 'SQL'; c_target_type_plsql constant t_target_type := 'PLSQL';
Data type constants to be used in the ADD_FILTER
or ADD_COLUMN
procedures.
c_data_type_varchar2 constant t_data_type := 1; c_data_type_number constant t_data_type := 2; c_data_type_date constant t_data_type := 3; c_data_type_timestamp constant t_data_type := 4; c_data_type_timestamp_tz constant t_data_type := 5; c_data_type_timestamp_ltz constant t_data_type := 6; c_data_type_interval_y2m constant t_data_type := 7; c_data_type_interval_d2s constant t_data_type := 8; c_data_type_blob constant t_data_type := 9; c_data_type_bfile constant t_data_type := 10; c_data_type_clob constant t_data_type := 11; c_data_type_rowid constant t_data_type := 12; c_data_type_user_defined constant t_data_type := 13;
Filter type constants to be used in the ADD_FILTER
procedures.
c_filter_eq constant t_filter_type := 1; c_filter_not_eq constant t_filter_type := 2; c_filter_gt constant t_filter_type := 3; c_filter_gte constant t_filter_type := 4; c_filter_lt constant t_filter_type := 5; c_filter_lte constant t_filter_type := 6; c_filter_null constant t_filter_type := 7; c_filter_not_null constant t_filter_type := 8; c_filter_starts_with constant t_filter_type := 9; c_filter_not_starts_with constant t_filter_type := 10; c_filter_ends_with constant t_filter_type := 11; c_filter_not_ends_with constant t_filter_type := 12; c_filter_contains constant t_filter_type := 13; c_filter_not_contains constant t_filter_type := 14; c_filter_in constant t_filter_type := 15; c_filter_not_in constant t_filter_type := 16; c_filter_between constant t_filter_type := 17; c_filter_not_between constant t_filter_type := 18; c_filter_regexp constant t_filter_type := 19; -- date filters: days/months/... c_filter_last constant t_filter_type := 20; c_filter_not_last constant t_filter_type := 21; c_filter_next constant t_filter_type := 22; c_filter_not_next constant t_filter_type := 23; -- interactive reports c_filter_like constant t_filter_type := 24; c_filter_not_like constant t_filter_type := 25; c_filter_search constant t_filter_type := 26; c_filter_sql_expression constant t_filter_type := 27; c_filter_expr_sep constant varchar2(1) := '~'; c_filter_expr_value_sep constant varchar2(1) := chr(1); -- interval types for date filters (last, not last, next, not next) c_filter_int_type_year constant t_filter_interval_type := 'Y'; c_filter_int_type_month constant t_filter_interval_type := 'M'; c_filter_int_type_week constant t_filter_interval_type := 'W'; c_filter_int_type_day constant t_filter_interval_type := 'D'; c_filter_int_type_hour constant t_filter_interval_type := 'H'; c_filter_int_type_minute constant t_filter_interval_type := 'MI';
Order by constants to be used in the ADD_FILTER
procedures.
c_order_asc constant t_order_direction := 1; c_order_desc constant t_order_direction := 2; c_order_nulls_first constant t_order_nulls := 1; c_order_nulls_last constant t_order_nulls := 2;
Constants or empty filter, order by, columns or parameter arrays
c_empty_columns t_columns; c_empty_filters t_filters; c_empty_order_bys t_order_bys; c_empty_parameters t_parameters;
Parent topic: APEX_EXEC