Pranav Bakare articles - 250 total
NONPARTITIONED ONLINE in Oracle SQL
In Oracle versions prior to 19c, if a table had only one partition, you could not drop that last...
Cursor Attributes in PLSQL
In the context of Oracle SQL, especially in PL/SQL, the different types of cursor attributes are used...
AWS services and concepts
As a developer, knowing the most famous AWS services and concepts can help you build, deploy, and...
Security Triggers in PL/SQL
When implementing security triggers in your PL/SQL, you should focus on the following three critical...
![[Boost]](https://media2.dev.to/dynamic/image/width=1000,height=500,fit=cover,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fv5j383w3vwgfxbjifjbv.png)
[Boost]
I Hope You Git It! - The Ultimate Git Guide for Beginners🚀 ...
Restore Points in Oracle SQL
Restore Points in Oracle SQL A restore point in Oracle SQL is a named marker that allows...
Liquibase, ChangeSet, and ChangeLog
Here are concise definitions for Liquibase, ChangeSet, and ChangeLog: Liquibase: A database schema...
WAR, JAR, EAR, and TAR - Archive file formats
WAR, JAR, EAR, and TAR are archive file formats with distinct purposes. WAR packages Java web...
Continuous Integration/Continuous Deployment (CI/CD) process
The pipeline steps you’ve mentioned correspond to a typical deployment workflow in a Continuous...
Journey From Java file to a JAR file
Step-by-step breakdown of how we go from a Java file to a JAR file, with a detailed explanation at...
FOR UPDATE statement
The SELECT ... FOR UPDATE statement is used in SQL to lock the selected rows in a table, ensuring...
Gitlab CICD Pipeline
When someone says they have built a CI/CD pipeline in GitLab, they mean they have created a process...
Merging and Deployment process with respect to SQL scripts
Let's break this down step by step to clear up the confusion. You're absolutely right that there's a...
PRAGMA AUTONOMOUS_TRANSACTION in ORACLE PLSQL - Use case
In the airline industry's cargo management system, autonomous transactions can play a critical role...
Step-by-Step Guide to Creating and Merging Feature Branches in Git
"Step-by-Step Guide to Creating and Merging Feature Branches in Git" Start by switching to the...
Shipment Lifecycle
Here’s a detailed explanation of each step in the Shipment Lifecycle to help you understand the...
Step-by-step guide of Gitlab flow
Step-by-step guide with descriptions for each command, starting with the flow explanation: Basic...
Feature Branch in Git
A feature branch is a branch in your Git repository that is created to work on a specific feature,...
Docker article Best
https://dev.to/juniourrau/introduction-to-docker-core-concepts-and-basics-for-beginners-4n0h
DTO & DAO in Software Development
DTO (Data Transfer Object) and DAO (Data Access Object) are key design patterns often used in...
Getting Started with GitLab
Getting Started with GitLab GitLab is a DevOps platform that provides version control, CI/CD...
Synonyms in Oracle SQL
In Oracle SQL, synonyms are database objects that serve as alias names for other database objects...
Pseudo Columns in Oracle SQL
When discussing pseudo columns in an interview, it’s important to focus on their practical...
Temporary Tables in Oracle SQL
Temporary Tables in Oracle SQL A Temporary Table in Oracle SQL is a special type of table...
Can we have multiple null values in a unique key column?
Yes, in Oracle SQL, you can have multiple NULL values in a column that is defined as a UNIQUE key....
ON DELETE CASCADE Usage with Foreign key
Definition of ON DELETE CASCADE The ON DELETE CASCADE clause is used in a database when...
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword
AUTO_INCREMENT in MySQL and Sequence in Oracle SQL In Oracle SQL, there is no...
SUBSTR and INSTR functions in Oracle SQL
In SQL, both the SUBSTR (or SUBSTRING in some databases) and INSTR functions are used to work with...
CASE and DECODE in SQL
CASE and DECODE in SQL In Oracle SQL, CASE and DECODE are control-flow functions used to...
Concepts of Cloud Computing that every Developer should know in 2025
When someone refers to having a strong knowledge of cloud computing platforms, they are typically...