Oracle Applications E-Learning Lab

  Create table structure  CREATE TABLE XX_TEMPLATE_FILE_UPLOAD_ALL (    TEMPLATE_ID         NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY,    TEMPLATE_NAME       VARCHAR2 (1000) DEFAULT 'File Upload',    FILE_NAME           VARCHAR2 (1000),    FILE_ATTACHMENT     BLOB,    MIME_TYPE           VARCHAR2 (1000),    FILE_CHARSET        VARCHAR2 (1000),    STATUS              VARCHAR2 (1000),    CREATION_DATE       DATE DEFAULT SYSDATE,    CREATED_BY          NUMBER DEFAULT 1,    LAST_UPDATE_DATE    DATE DEFAULT SYSDATE,    LAST_UPDATED_BY     NUMBER DEFAULT 1,    LAST_UPDATE_LOGIN   NUMBER DEFAULT 1,   ...

No matter what the business is, there is always a common requirement to upload file data into a database table. In this article, we will learn how to upload a data file in Oracle APEX and verify how the data appears in the database table. First, create a table: CREATE TABLE xx_file_upload (     file_upload_id NUMBER         GENERATED BY DEFAULT ON NULL AS IDENTITY,     name           VARCHAR2(100),     dob            DATE,     designation    VARCHAR2(100),     location       VARCHAR2(100),     salary         NUMBER,     CONSTRAINT file_upload_id_pk PRIMARY KEY ( file_upload_id ) Next, create a data file with the sample data as shown below. Save the file with any name. I am naming it SampleFileUpload.csv . The next step is to create an application and go to the Shared Components secti...

 In Oracle APEX, Interactive Reports offer a powerful way to organize and display data. One often-overlooked enhancement is styling column groups and their corresponding columns to improve visual clarity and user experience. This blog guides you through how to color column group headers and their underlying columns using both CSS and JavaScript . Step 1: Assign a Static ID to the Interactive Report Open your APEX page in Page Designer . Select the Interactive Report region. Under the Advanced section, set the Static ID This ID helps us target the report with custom code. Step 2: Identify Column Groups You Want to Style Suppose you want to color these column groups: End Item Info Sales Info To identify them: 1.  Run the page and open the browser’s Developer Tools (Right-click > Inspect) 2. Locate the column group headers and note the attribute data-idx (e.g., data-idx="1" for End Item Info, data-idx="2" for Sales Info). To color only col...