load files

How To Generate Dynamic Numbers in MYSQL

Introduction: Generating dynamic numbers in MySQL involves creating a sequence of numbers or generating numbers dynamically in queries. This is useful in various scenarios, such as creating IDs, generating row…

Read More

Script to upload multiple LDT files for a Concurrent Program/Alert/Form/ValueSet/XML Definations in a Single time

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 More

How To Insert Data from One Database into Another Database Using Apache Nifi

Introduction: – 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 More

Using Oracle Forms to load local files

using the below code In load file “button” using “when-button-pressed” trigger. DECLARE    l_userhome            VARCHAR2 (200)          := webutil_clientinfo.get_system_property (‘user.home’)             || ‘Desktop’;    l_filename            VARCHAR2 (200) := NULL;   …

Read More