Yearly Archives: 2024

Quick Menu Navigation In APEX

1.Overview In Oracle APEX quick menu navigation is essential for creating a user-friendly and efficient application. Implement a quick search functionality to allow users to find specific pages or records quickly.…

Read More

Transferring file from one server to another using sftp in shell script

  1. Overview In this document, we will explore a shell script named sftp_file_transfer.sh that automates the process of transferring files from one server to another.   2. Technologies and…

Read More

Nested Reports in Oracle APEX

1. Overview The document will talk about nesting a report inside another report using the technologies like Oracle APEX, JavaScript, HTML. In Oracle APEX, embedding a nested report within a customized…

Read More

Sending email alert with multiple attachment using shell script

  1.   Overview In this document, we will explore how to create a simple yet effective shell script to send email alerts with multiple attachments.   2.   Technologies and Tools…

Read More

Creating Dynamic SQL Generator in Oracle PL/SQL

Table of Contents Introduction Technologies and Tools Used Steps Conclusion 1. Introduction The Dynamic SQL Generator in Oracle PL/SQL allows you to dynamically construct SQL statements, providing flexibility and reusability…

Read More

Optimizing Workspace Security: Setting “Session Idle Timeout” URL in Oracle APEX

Introduction: In the realm of Oracle APEX administration, ensuring robust security measures is paramount. One crucial aspect is managing the session idle timeout for work spaces. This guide provides a…

Read More

Enhancing Data Input Efficiency with APEX Multi Row Item Plugin

Overview The APEX-Multi Row-Item-Plugin is a free and open-source plugin for Oracle Application Express (APEX) that allows you to create multi-row input fields within your applications. This could be part…

Read More

Automating the APEX Installation Process

Introduction: Streamline your Oracle APEX installation with ease using a silent installation script. This blog explores a quick and efficient method for deploying APEX instances, simplifying the process for developers…

Read More

Efficient Date Picking: Exploring the APEX Scroll-able Date Picker Plugin

Overview The Scroll-able Date Picker Plugin for Oracle APEX enhances the user experience with features like scroll-able calendars, drag-and-select functionality, and mobile-friendly design. It simplifies date selection on various screen…

Read More

Oracle EBS – Archive the file with Script

By using the bleow script, we can archive the file from specific folder to back up folder in the server location.   # =============================================================================+ export ora_login=$1 export ora_userid=$2 export login_name=$3…

Read More