Oracle APEX Collections Concepts and Practice Session

In this comprehensive video, I delve into the intricate world of Collections in Oracle APEX, breaking down essential concepts and providing a practical session to reinforce your understanding. Collections play a pivotal role in Oracle APEX development, serving as temporary storage areas that enable efficient data manipulation within your application. Throughout the video, I demystify the intricacies of Collections, offering clear explanations and practical insights to empower both beginners and experienced developers alike. Whether you're looking to grasp the fundamentals or enhance your existing knowledge, this video serves as a valuable resource to navigate the complexities of Collections in Oracle APEX.
The practice session in this video provides a hands-on experience, allowing viewers to apply the concepts learned in a real-world scenario. By walking through practical examples, you'll gain a deeper understanding of how to leverage Collections effectively in your Oracle APEX applications. From defining and populating Collections to manipulating data within them, this video equips you with the skills needed to optimize your development workflow. Join me on this educational journey as we bridge theory and application, unraveling the power of Collections in Oracle APEX for seamless data management and application development.
Code Link
www.erpstuff.com/viewtopic.ph...

[@samirkhanra6961]

Hello Sir, This is really a nice video. I have learnt a lot on this topic

[@ERPstuff]

Glad to hear that

[@bhavinadhvaryu8549]

Thank you for sharing the video. Very easy explanation, really nice video. Could you please add functionality to process the collection rows to/from the database (DML functionality). Thank you!

[@ERPstuff]

Just use a loop and insert into your table once processing completed as data is there in APEX_COLLECTIONS.

[@bhavinadhvaryu8549]

@@ERPstuff Thanks so much for your prompt reply. I will do accordingly. Thank you!

[@fahdbahoo1]

We can make our own table to get same functionality, what is so special about collections ?

[@ERPstuff]

The purpose of this is to work in memory instead of reading and writing in disk. Table means to read and write to disk and it is mentioned in the video. Its a feature in Oracle APEX you want to use then you can else you can skip it. thanks

[@fahdbahoo1]

@@ERPstuffi want to use, but i need to understand. How it is in memory ? collection is also a table, data is being written to disk. calling to collection functions are servers calls it is not Javascript saving data on client side

[@ERPstuff]

It is kept in the current session only so no need to write in disk. This is what I know and if you have any specific information please do share URL. Thanks

[@fahdbahoo1]

HTTP is stateless, so data must be written to disk

[@ERPstuff]

this is a feature it might suit you or another user. thanks