A to Z Apex Collection in Oracle Apex Application | Oracle apex collection a to z

#oraclelearner #oracleapex #apexcollection
In this video we learn oracle apex collection as like how to create collection, how to add member in the collectin, how to collection data insert into the database through the collection and clear or delete the collection.
►► How we will do:
1. We need to Create Page & Page Item
2. Create a Create button.
3. Create another region where collection data will show.
4. Create a dynamic action that will create collection.
5. create a true action that will refresh emp info region
6. Select collection on the emp info region.
7. create another button that will delete apex collection when the button is clicked.
8. create a dynamic action that will delete the collection.
9 Create another true action that refresh emp info region.
10 Create another button when the button is clicket the collection data will insert into the database.
11. Create a process that will collection data insert into the table through the collection.
-----------------------------------------
►►Our Published Video Link :
WhatsApp Message from Oracle Apex: • Send Message from Orac...
Post Authentication: • Post Authentication in...
Schedule Calender: • How to create Schedule...
Sign Up Email verification: • Sign In Verification i...
Procedure base Post Method API: www.youtube.co....
Collection A to Z: www.youtube.co....
Delete page Recover: www.youtube.co....
Facebook Authentication: www.youtube.co....
Google Authentication: www.youtube.co....
Recaptcha: www.youtube.co....
Notification Menu: www.youtube.co....
Signature Plugin: www.youtube.co....
Web Source Report: www.youtube.co....
Report Download Plugin: www.youtube.co....
►► For More Videos,
Please Subscribe our Channel:
/ oraclelearner
------------------------------------------
►► Our Blog:
orclapexlearne...
Thank you

[@ravikhanthdaram7713]

Hi, Could you pls let us know how can we select all the data from interactive reports into collection. I have a requirement to get the from grid data from previous year and update those records/ add more records and insert them into same table with current year data(append)

[@Little_Pianist06]

how we update the apex collection

[@AmanUllah-wz4cr]

উপস্থাপনাতো সুন্দর হয়েছে। কিন্তু শ্বাস-প্রশ্বাস নিয়ন্ত্রণ করাটাও জরুরী ছিলো। খুবই বিরক্তিকর লাগছে। ভবিষ্যতে খেয়াল করবেন।

[@muhammadismailmehtab]

HOW TO DISTINCT AND SUM IN COLLECTION
IN THIS SCENARIO DISTINCT OR GROUP BY (C001 P37_ITEM_ID) AND SUM (C003 QTY)
SELECT C001 P37_ITEM_ID,C002 RATE,C003 QTY,seq_id,C002*C003 TOTAL
FROM APEX_COLLECTIONS WHERE COLLECTION_NAME ='CART'