People and Culture Blog

Upgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool

This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.…

Read More

Converting a Non-CDB to PDB using remote cloning method

This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method. Note: Non-CDB and target CDB are on different hosts (both on-premises) Create…

Read More

Exploring the significance and utility of responsive number counters in Oracle APEX applications

Overview A responsive number counter is not only capable of displaying numeric values but also adjusts its appearance. It provides a means to present data or perform calculations based on…

Read More

Installation of Autonomous Transaction Processing (ATP) Database

OVERVIEW: Oracle Autonomous Transaction Processing (ATP) is a cloud-based, fully managed database service by Oracle. It automates administrative tasks, enabling users to focus on application development. ATP is optimized for…

Read More

MongoDB Backup and Restore

This blog post will discuss the process of backing up and restoring a MongoDB database using the built-in commands and tools provided by MongoDB. To perform a data backup in…

Read More

GridFS file system on Mongodb

Introduction to Grid FS: MongoDB has a 16 MB limit for normal document size. To store larger files, MongoDB offers Grid FS, which divides files into smaller chunks stored as…

Read More

PERFORMANCE TUNNING IN MSSQL

INTRODUCTION SQL tuning is the process of improving SQL queries to accelerate your servers performance. It’s general purpose is to reduce the amount of time it takes a user to…

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

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

Elevating Security with Oracle Database 23c: Schema-Level Grants Unveiled

Introduction: In the world of database management, developers used to face a tough decision – either spend time granting specific permissions for each table or take the risky route of…

Read More