How to Data load into the database by Prowse File Item | Browse File dat...

on




►► How we will do:



1. Install Plugins

2. Create a Page and create Browse file Item

3. Create a button

4. Create a process and select the plugin

5. set browse file Item name and give Collection name.

6. Create another region that will show collection data

7. Create button that when the button is clicked the collection data is insert into the table.

8. Create another button that when button is clicke the collection data is clear or delete. 

-----------------------------------------

Select Coollection:



Select seq_id  seq,

        C001 EMPNO,

        C002 ENAME,

        C003 JOB,

        C004 MGR,

        C005 SAL,

        C006 COMM,

        C007 DEPTNO

APEX_ITEM.CHECKBOX(1,seq_id,'CHECKED') "CHECKBOX"

from apex_collections

where collection_name = 'EMP_XL_DATA'

--and  seq_id>1

--------------------



Data Load Process:

Declare
vId         Number;
Begin
If apex_application.g_f01.count <> 0 then

For i in 2..apex_application.g_f01.count loop
vId :=TO_NUMBER(nvl(apex_application.g_f01(i),0));

IF NOT APEX_COLLECTION.COLLECTION_EXISTS('EMP_XL_DATA') THEN

APEX_COLLECTION.CREATE_COLLECTION('EMP_XL_DATA');

END IF;
        DECLARE
                CURSOR C1 IS 
                        SELECT 
SEQ_ID,
C001 EMPNO,
C002 ENAME,
C003 JOB,
C004 MGR,
C005 SAL,
C006 COMM,
C007 DEPTNO,
FROM APEX_COLLECTIONS C
                WHERE C.COLLECTION_NAME = 'EMP_XL_DATA' 
                 AND SEQ_ID = vID
                        ; 
                      
        BEGIN
           
           FOR REC_C1 IN C1 LOOP
   
  
           BEGIN
           
       INSERT INTO EMP (

EMPNO,
ENAME,
JOB,
MGR,
SAL,
COMM,
DEPTNO
       )
                    VALUES ( 
                    REC_C1.EMPNO,
                    REC_C1.ENAME,
                    REC_C1.JOB,
                    REC_C1.MGR,
                    REC_C1.SAL,
                    REC_C1.COMM,
                    REC_C1.DEPTNO
               
               
               );
   
    EXCEPTION WHEN OTHERS THEN NULL;
      END;
  
  
            END LOOP;
       END;
       
END LOOP;
End if;
End;
          
-------------


Delete Collection :


begin
APEX_COLLECTION.DELETE_COLLECTION(
        p_collection_name => 'EMP_XL_DATA');
exception when others then null;
end;



►►Our Published Video Link : Procedure base Post Method API: https://www.youtube.com/watch?v=wp67G... Collection A to Z: https://www.youtube.com/watch?v=d3GOd... Delete page Recover: https://www.youtube.com/watch?v=ymWu2... Facebook Authentication: https://www.youtube.com/watch?v=n7sTE... Google Authentication: https://www.youtube.com/watch?v=ZqOzQ... Recaptcha: https://www.youtube.com/watch?v=0K0Fn... Notification Menu: https://www.youtube.com/watch?v=6zlaW... Signature Plugin: https://www.youtube.com/watch?v=NpwjR... Web Source Report: https://www.youtube.com/watch?v=AV-zj... Report Download Plugin: https://www.youtube.com/watch?v=5ofWg... ►► For More Videos, Please Subscribe our Channel: https://www.youtube.com/channel/UCwsr... ------------------------------------------ ►► Our Blog: https://orclapexlearner.blogspot.com/ Thank you



Comments

Post a Comment