Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time Use-Case: In general during the migration process/Go-Live the downtime of the server will be…
Read MoreIntroduction: – In modern data management, transferring data between different databases is a common requirement. Apache NiFi, an open-source data integration tool, provides a powerful and flexible solution for this…
Read MoreTable 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 MoreOverview : The objective is to enhance Oracle APEX Application Availability through the implementation of PL/SQL code, ensuring uninterrupted and reliable operation by monitoring, managing, and responding to potential factors…
Read MoreOverview : The primary objective of this content is to guide users on how to handle client secret expiry in Azure Authentication for Oracle APEX. Specifically, the content provides step-by-step…
Read MoreExternal table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control file having issue to load…
Read MoreIntroduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error: SQL> alter database mount; alter database…
Read More1. Overview This document talks about how to create a data source for java project using Oracle Web logic server. 2. Technologies and Tools Used The following technologies have been…
Read More1. Overview This document explains how to create a Drag and Down the rows using Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve…
Read MoreUse RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read More