Editable Interactive Report in Oracle Apex || oracle apex tutorial

****************Create table*************** 

CREATE TABLE BACKUP_EMP

( EMPNO VARCHAR2(100)

,ENAME VARCHAR2(100)

,JOB VARCHAR2(100)

,MGR VARCHAR2(100)

,SAL VARCHAR2(100)

,COMM VARCHAR2(100)

,DEPTNO VARCHAR2(100)

);

 ********Create interactive Report and collection or table column and use this code***************

 select

SEQ_ID,

APEX_ITEM.text(p_idx => 1, p_value => c001) AS EMP_NO,

APEX_ITEM.text(p_idx => 2, p_value =>c002 )EMP_NAME,

APEX_ITEM.text(p_idx => 3, p_value =>c003) JOB,

APEX_ITEM.text(p_idx => 4, p_value =>c004) MANAGER,

APEX_ITEM.text(p_idx => 5, p_value =>C005) SALARY,

APEX_ITEM.text(p_idx => 6, p_value =>c006) COMM,

APEX_ITEM.text(p_idx => 7, p_value =>C007) DEPT_NO

from 

apex_collections

where collection_name = 'ITEM_DETAILS';

************Insert Data into table using this code ***************

FOR I IN 1..APEX_APPLICATION.G_F01.COUNT LOOP

insert into backup_EMP

(

 EMPNO

,ENAME

,JOB

,MGR

,SAL

,COMM

,DEPTNO

)

values

(

 APEX_APPLICATION.G_F01(I),

 APEX_APPLICATION.G_F02(I),

 APEX_APPLICATION.G_F03(I),

 APEX_APPLICATION.G_F04(I),

 APEX_APPLICATION.G_F05(I),

 APEX_APPLICATION.G_F06(I),

 APEX_APPLICATION.G_F07(I)

    );

    

    END LOOP;

    

Stay Informed:  Stay up-to-date with the latest Oracle APEX tips and updates by following my social media profiles.

 Follow on YouTube:  Dive deeper into Oracle APEX by exploring my YouTube channel for tutorials and insights: 

 YouTube Channel: YouTube

Connect on LinkedIn:  Let's connect on LinkedIn for networking opportunities, discussions, and more: 

 LinkedIn Profile: Linkedin