How to use the Apex collection and create a report. Part-1

How to use the Apex collection and create a report. Part-1

 

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.

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

🔗 SaveCollection 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 use the Apex collection, Part-1

1. CREATE TABLE STUDENT, TRIGGER . 

  CREATE TABLE  "STUDENT"    ( "STUDENT\_ID" NUMBER,  "STUDENT\_NAME" VARCHAR2(250),  "ADDRESS" VARCHAR2(250),  "PHONE" NUMBER,  "DATE1" DATE,   CONSTRAINT "STUDENT\_CON" PRIMARY KEY ("STUDENT\_ID")  USING INDEX  ENABLE   ) / CREATE SEQUENCE "STUDENT\_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 381 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL / CREATE OR REPLACE EDITIONABLE TRIGGER  "STUDENT"          before insert on "STUDENT"         for each row       begin         if :NEW."STUDENT\_ID" is null then        select "STUDENT\_SEQ".nextval into :NEW."STUDENT\_ID" from sys.dual;          END IF;    END; / ALTER TRIGGER  "STUDENT" ENABLE

2. Create a New Blank page. 

3. Create a New Region. Name-Apex Collection From.

4. Create a few items like your needs.
 Example- 1-STUDENT_ID, 2-STUDENT_NAME, 3-ADDRESS, 4-PHONE, 5-DATE1

5. Create a Button, Nane- Add Data .

6. Create a New Region. Name-Apex Collection Report.>> SQL Query >> Paste the following code

  Select seq\_id SL\_NO, c001 STUDENT\_ID, c002 STUDENT\_NAME, c003 ADDRESS, c004 PHONE, c005 DATE1, seq\_id id, seq\_id edit from apex\_collections where collection\_name = 'STUDENT'

7. Create a Process >> Name- PRIMARY KEY, >> PL/SQL Code >>

  SELECT STUDENT\_SEQ.NEXTVAL INTO :P8\_STUDENT\_ID FROM DUAL;

When Button Pressed >> Add Data. 

8. Create a Process >> Name- Add Collection, PL/SQL Code >>

  BEGIN    IF NOT apex\_collection.collection\_exists ('STUDENT')    THEN        apex\_collection.create\_collection ('STUDENT');    END IF;    apex\_collection.add\_member (p\_collection\_name   => 'STUDENT',                                p\_c001              => :P8\_STUDENT\_ID,                                p\_c002              => :P8\_STUDENT\_NAME,                                p\_c003              => :P8\_ADDRESS,                                p\_c004              => :P8\_PHONE,                                p\_c005              => :P8\_DATE1); END;

WHEN Button Pressed >> ADD Data.

9. Create a Dynamic Action >> Page Load>>

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

 

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