APEX_COLLECTION Using CREATE_COLLECTION_FROM_QUERY_B and CREATE_COLLECTION_FROM_QUERY_B2

Referred from Oracle Standard Document . CREATE_COLLECTION_FROM_QUERY_B Procedure Use this procedure to create a collection from a supplied query using bulk operations. This method offers significantly faster performance than the CREATE_COLLECTION_FROM_QUERY method. The query is parsed as the application owner. If a... Read more

Upload Multiple Files in Oracle APEX

How to upload multiple files in apex collection using Oracle APEX. Read more

How to query APEX collection data from database

How to query APEX collection from database Oracle APEX has APEX_COLLECTION utility to store data per session, which is really useful when we need to store data temporarily and can be posted after the performing validations/ calculations. APEX collection is... Read more