Making Intellectuals Meet Excellence!
In SQL, joins combine rows from two or more tables based on related columns. This is crucial when working with normalized databases to extract meaningful insights. 1. INNER JOIN An INNER JOIN fetches only the rows with matching values in both tables. Example: Consider these tables: Query to perform INNER JOIN SELECT Customers.Name, Orders.Product FROM […]
Handling Large Objects (LOBs) efficiently is crucial when working with large data in Oracle databases. SecureFile LOBs offer a high-performance and storage-efficient solution for managing LOBs in PL/SQL. This blog will explore SecureFile LOBs, their features, and how to use them effectively in PL/SQL. What Are SecureFile LOBs? SecureFile LOBs are an advanced type of LOB storage […]
SQL injection is one of the most common vulnerabilities in database applications. Attackers exploit this vulnerability to manipulate queries, steal data, or compromise systems. This blog explains SQL injection, demonstrates how it occurs, and provides effective prevention strategies, focusing on PL/SQL. What is SQL Injection? SQL injection occurs when attackers insert malicious SQL statements into […]
Terraform can import existing infrastructure resources. This functionality lets you bring existing resources under Terraform management. Terraform is not able to auto- generate configurations for those imported modules, for now, and requires you to first write the resource definition in Terraform and then import this resource. Import will find the existing resource from ID and […]
Minikube is a lightweight Kubernetes cluster that creates a single-node cluster in a virtual machine (VM) on your local machine. It quickly creates a local Kubernetes cluster on macOS, Linux, and Windows. Prerequisites 1. Before installing the minikube it is recommended to install all available updates on your system. sudo apt updatesudo apt upgrade -y […]
In Kubernetes, effective resource management for pods and containers is crucial for maintaining performance and stability in the cluster. Understanding how to specify and manage CPU and memory resources will help us to ensure that applications will run efficiently without overloading nodes. When you create a Pod, you can specify how many resources a container […]
Function is a block of statements that return the specific task. The idea is to put some commonly or repeatedly done tasks together and make a function so that instead of writing the same code again and again for different inputs, we can do the function calls to reuse code contained in it over and […]
In May 1994, Oracle introduced the Dynamic SQL concept in its Database version 7.1. With this it enabled developers to write the dynamic SQL through “DBMS_SQL” package. But, because of its “Not So Easy” syntaxes, the “Sluggish Performance” and “Unsupported User-Defined Types”, the DBMS_SQL library was not very successful. All these shortcomings raised the need […]
Managing Code is the very first step in the DevOps Cycle. Git is the Most Common Version Control System used Among the Programmers. Imagine a team of five members who are working on master source code enhancing different features to it. Just think, how can they work on the same source code without confusion on […]
API (Application Programming Interfaces) Application Programming Interfaces Stand in HTML5. It is a set of routines, protocols, and tools for building software applications. An API is a collection of pre-built components, that can be used with JavaScript It is a set of programming codes that enables data transmission between one software application, website, and another. […]