oracle apex docs code example
Example: oracle apex collection
APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY_B (
p_collection_name IN VARCHAR2,
p_query IN VARCHAR2.
p_names IN apex_application_global.vc_arr2 DEFAULT,
p_values IN apex_applicatioN_globa.vc_arr2 DEFAULT,
p_max_row_count IN NUMBER DEFAULT);