Pranav Bakare articles - 250 total
Cursor and It's Types in Oracle Database
Implicit Cursor Explicit Cursor RefCursor SysRefCursor 🔹 1. Implicit Cursor Created automatically...
DBMS_SCHEDULER.CREATE_JOB in Oracle
🛠 A Comprehensive Guide to DBMS_SCHEDULER.CREATE_JOB in Oracle Automating tasks in Oracle Database...
Constraints and Indexes on Oracle Tables Using Data Dictionary Views
🔍 How to Inspect Constraints and Indexes on Oracle Tables Using Data Dictionary Views Oracle...
Foreign Keys in SQL
🔗 Understanding Foreign Keys in SQL: A Complete Guide (Oracle-Focused) ✅ What is a Foreign Key? A...
Indexing In Oracle Database
In Oracle, there are multiple ways to define (declare) indexes, depending on the type of index and...
Audit Table with Trigger in Oracle Database
🔍 Audit Table with Trigger – Core Concept Audit tables are used to log changes (INSERT, UPDATE,...
Audit Tables in Oracle SQL Database
✅ What Are Audit Tables? Audit tables are auxiliary tables used to log and track changes (INSERT,...
DBMS_SCHEDULER in ORACLE Database
🧠 What is DBMS_SCHEDULER? DBMS_SCHEDULER is a built-in Oracle PL/SQL package that allows you to...
External Tables in Oracle
🔍 External Tables in Oracle: Querying File-Based Data Without Inserting It In the world of...
TRIM vs RTRIM function in ORACLE SQL
The main difference between TRIM and RTRIM is how they handle whitespace (or other specified...
Data Dictionary Views (tables)
Data Dictionary (or Data Dictionary Views) ✅ What is the Data Dictionary? The Data Dictionary is a...
Security Trigger | D1
Security Trigger SELECT table_owner,trigger_name, table_name, triggering_event, trigger_type,...
Creation of a table | Primary key constraint | Sequence | Public synonyms with Grants
Script defines the creation of a table, a primary key constraint, a sequence, and public synonyms...
Stale User session
A stale user session in a system refers to a session that has become inactive, outdated, or no longer...
What is continuous integration (CI)
What is continuous integration (CI)? Continuous integration is the practice of integrating all your...
DevOps for Cloud Engineers....
📑 DevOps for Cloud Engineers Cloud Engineering and DevOps go hand in hand. CI/CD makes...
Top 5 things that will help you during your Interview Process
Helpful Tools and Platforms During Interview Preparation: LinkedIn Useful for networking and...
DB developer to QA to UAT
Flow: DB Developer (Unit Testing) ↓ QA (System + Integration + Regression Testing) ...
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...