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

How To Update And Delete Data From Apex Collection. Part-3

 

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 update and delete Apex collection data. 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 Update Data Use Apex collection ?

1. Create a New Page-item Name- Edit.

2. Go To The Edit Of The Report. 

3. Change Type >> Link.       Target --> Type --> Url --> Paste The Following Code

	                    
                        
javascript : $s('P8_STUDENT_ID', '#STUDENT_ID#');
javascript : $s(
 'P8_STUDENT_NAME', '#STUDENT_NAME#'
);
javascript : $s('P8_ADDRESS', '#ADDRESS#');
javascript : $s('P8_PHONE', '#PHONE#');
javascript : $s('P8_DATE1', '#DATE1#');
javascript : $s('P8_EDIT', '#ID#');

Link Text --> 

	                    
                        
< img src = "#IMAGE_PREFIX#app_ui/img/icons/apex-edit-pencil-alt.png" class = "apex-edit-pencil-alt" alt = "" >

4. Create a Button, Name-Apply_Changes       Create a Dynamic Action --> Name-Update Data
       Action >> Execute Server-side code -->        PL/SQL Code --> Paste the following code

	                    
                        
Begin APEX_COLLECTION.UPDATE_MEMBER (
 p_collection_name => 'STUDENT', p_seq => : P8_EDIT, 
 p_c001 => : P8_STUDENT_ID, p_c002 => : P8_STUDENT_NAME, 
 p_c003 => : P8_ADDRESS, p_c004 => : P8_PHONE, 
 p_c005 => : P8_DATE1
);
End;

Items to Submit --> All Item

Create Action --> Refresh --> Selection Type --> Region --> Report. 

Create Action --> Clear --> Selection Type --> Item(s) --> All Item. 

Steps On How To Delete Data Use Apex collection ?

5. Create a New Page-item, Name- Delete.

6. Go to the ID of the report. 

7. Change Type --> Link.

      Target --> Type --> Url --> Paste the following code 

	                    
                        
javascript:$s('P8_DELETE','#ID#');

Link Text --> 

8. Create a dynamic action Delete items --> Name-Delete Data

    Client-side Condition --> Type --> Item is not null,

    Action --> Execute Server-side code --> PL/SQL Code --> Paste the following code

	                    
                        
Begin APEX_COLLECTION.DELETE_MEMBER(
 p_collection_name => 'STUDENT', p_seq => : P8_DELETE
);
End;
 

Items to Submit --> P8_DELETE

Create Action --> Refresh --> Selection Type --> Region --> Report. 

Create Action --> Clear --> Selection Type --> Item(s) --> P8_DELETE 

9. Hide the item P8_EDIT, P8_DELETE duo at the end of all. 

 

🔗 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.........................