Oracle Applications E-Learning Lab

  CSS -- INLINE  .email-red-box {   background-color: #ffcdd2;   color: #b71c1c;   font-weight: bold;   padding: 6px 10px;   border-radius: 4px;   text-align: center; } .email-green-box {   background-color: #c8e6c9;   color: #1b5e20;   font-weight: bold;   padding: 6px 10px;   border-radius: 4px;   text-align: center; } SELECT     hou.name,     cust_mail.party_name,      cust_mail.account_number,          cust_mail.invoice_number,      cust_mail.invoice_date,      cust_mail.amount,       cust_mail.creation_Date,         cust_mail.email_address,       CASE   WHEN cust_mail.EMAIL_STATUS = 'EMAIL DELIVERED'     THEN '<div class="email-green-box">EMAIL DELIVERED</div>'   ELSE '<div class="email-red-box">EMAIL NOT DELIVERED</div>'  END...

  .apex-igrid .a-GV-w-hdr { overflow-x: auto !important; /* Enable horizontal scrolling in the grid header */ }

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