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