Set Menu To User Access Role, User Authentication, Part-6

How to Save Collection Data. Apex Collection Part-2

 

When a user clicks or saves any data, it is the easiest way to create a report by holding the data according to the user session without saving the data in the database.

     I will try to show you how to create reports, update data and delete data through Apex Collection. If you watch all the videos of my Apex Collection, hopefully you will get a complete idea about Apex Collection. In the next video, I will try to show you how to update the data of Apex Collection.

In today's tutorial, I will show you how to save Apex Collection data in a database.

If you haven't seen the previous videos on my Apex Collection, please watch the video by clicking on the link in the description.

🔗 Apex collection and Report, Part-1 Video Url--
            URL-https://youtu.be/jARSMQcAgu4
 

🔗 Save Collection Data, Part-2 Video Url--
            URL-https://youtu.be/3zsh1OrBKSQ
 

🔗 Update and Delete Data, Part 3 Video Url--
            URL-https://youtu.be/Vz_2AOm6BrE
 

Steps On How to Save Collection Data, Apex Collection Part-2

1. Create a Button, Name- Save_Data

2. Create a Process- >> Name- Data Save, PL/SQL Code >>

	                    
                        
BEGIN
   INSERT INTO STUDENT (STUDENT_ID,
                        STUDENT_NAME,
                        ADDRESS,
                        PHONE,
                        DATE1)
       SELECT c001,
              c002,
              c003,
              c004,
              c005
         FROM apex_collections
        WHERE collection_name = 'STUDENT';
   APEX_COLLECTION.DELETE_COLLECTION (p_collection_name => 'STUDENT');
END;

When Button Pressed- >> Save_Data.

 

🔗 Demo Application-
            URL- Demo Application
            Username - demo, Pass- demo
 

I hope everyone will like it. Please watch the full video,
Comment on any of your problems, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable. Visit my blog site, new technology related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
Please stay tuned by subscribing to the YouTube channel, and encourages new videos to be uploaded.
=================
Visit my site to get more collaborative posts about Oracle Apex and subscribe to my YouTube channel. Thanks.
Comment on any of your issues, I will try my best to solve the problem, In-Shah Allah. Everyone's cooperation is desirable.
Visit my blog site, new technology-related videos, you will get different types of tutorials of Oracle Apex, and hopefully, you can use them in your daily work.
==============================

🙍🏾‍ Md jABER HOSSEN
📲 Mobile- +8801760688286
📨 Email- jaberit786@gmail.com
🌐 FB- facebook.com/mdjaber.hossen1
Please Subscribe to My Channel

Many thanks for visiting the site.

Then Enjoy.........................