People and Culture Blog

Delete Data Using AJAX

1. Overview We know that there is an button option to delete record  in oracle apex. But in some scenarios we may have to delete records instead of buttons but on report…

Read More

Aliasname_Groupby_Blog

ORACLE 23-C NEW FEATURES Using column alias name in GROUP BY & HAVING clause Using column position in GROUP BY & HAVING clause  CONTENTS SNO CONTENTS PAGE NUMBER 1 Introduction…

Read More

Count characters in input item

1. Overview We know that there is an inbuilt option to restrict character count in oracle apex. But in some scenarios we may have to know how many characters we have entered in…

Read More

Viewing alert log for Amazon RDS for Oracle

This blog is intended for Oracle DBA’s administering Amazon RDS for Oracle. Issue: Oracle DBAs may need to view alertlog for the database, for troubleshooting issues and looking out for…

Read More

Concurrent Program Output Saving as FNDWRR.txt

Using Edge Browser Concurrent Program Output Saving as FNDWRR.txt  SYMPTOMS: Using Edge browser when concurrent program output is saved the output file name defaulting to FNDWRR.txt.This is happening only for…

Read More

Online reorganization of a table using Oracle DBMS_REDEFINITION package

This blog is intended for DBA’s who would like to reorganize tables online using Oracle dbms_redefinition package. Issue: DBAs may need to reorganize tables to improve the SQL query performance…

Read More

Merge PDF in AOP

1. Overview This document talks about how to merge the pdf in AOP. 2. Technologies and Tools Used The following technologies has been used to achieve exporting IR data to…

Read More

HTML Templates in AOP

1. Overview This document gives an idea about the HTML template in AOP. 2. Technologies and Tools Used The following technologies has been used to achieve exporting IR data to…

Read More

PHONE NUMBER VALIDATION USING PLUGIN IN OUTSYSTEMS

INTRODUCTION: Phone number validation is a common requirement for ensuring that users provide valid and correctly formatted phone numbers. Proper phone number validation is essential to prevent incorrect or invalid…

Read More

DATA AGGREGATION USE CASES IN OUTSYSTEMS

INTRODUCTION: Aggregate  is used to fetch data from database. If the Data model had any changes aggregation  automatically get that and load the database data from the server. Using aggregate we can perform…

Read More