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

Whenever a UI application displays a large result set with many rows and columns, navigation can become cumbersome. Users often need to scroll vertically to view records and then scroll back to the top to access the horizontal scroll bar in order to view additional columns. This negatively impacts usability and overall user experience. We encountered a similar challenge with an Oracle APEX Interactive Grid report that contained a high number of columns. Navigating across columns while reviewing rows became difficult and inefficient for users. To address this issue and enhance the visual and navigation experience, we implemented a horizontal scroll bar at the top of the Interactive Grid . This allows users to navigate columns easily without scrolling back to the top of the report repeatedly. This article outlines the step-by-step approach to adding a top horizontal scroll bar to an Interactive Grid in Oracle APEX. Step 1: Add Custom CSS at the Page Level Navigate to the required ...

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