DEV Community

Pranav Bakare profile picture

Pranav Bakare

Oracle Full Stack Developer

Work

ORACLE PLSQL DEVELOPER at TCS

Synonyms in Oracle SQL

Synonyms in Oracle SQL

Comments
3 min read

Want to connect with Pranav Bakare?

Create an account to connect with Pranav Bakare. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Pseudo Columns in Oracle SQL

Pseudo Columns in Oracle SQL

Comments
3 min read
Temporary Tables in Oracle SQL

Temporary Tables in Oracle SQL

10
Comments
2 min read
Can we have multiple null values in a unique key column?

Can we have multiple null values in a unique key column?

Comments
2 min read
ON DELETE CASCADE Usage with Foreign key

ON DELETE CASCADE Usage with Foreign key

11
Comments
2 min read
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

Comments 1
1 min read
SUBSTR and INSTR functions in Oracle SQL

SUBSTR and INSTR functions in Oracle SQL

Comments
2 min read
CASE and DECODE in SQL

CASE and DECODE in SQL

Comments
2 min read
Concepts of Cloud Computing that every Developer should know in 2025

Concepts of Cloud Computing that every Developer should know in 2025

1
Comments
3 min read
ETL tools

ETL tools

Comments
2 min read
AWR, ADDM, and ASH in Oracle SQL

AWR, ADDM, and ASH in Oracle SQL

Comments
1 min read
Advanced JavaScript concepts that every Javascript devloper should know!

Advanced JavaScript concepts that every Javascript devloper should know!

Comments
4 min read
Subquery in Oracle SQL

Subquery in Oracle SQL

Comments
3 min read
Temporary table in context of ORACLE SQL

Temporary table in context of ORACLE SQL

Comments
2 min read
DBMS_Scheduler in Oracle SQL

DBMS_Scheduler in Oracle SQL

10
Comments
4 min read
INSTEAD OF Trigger | Oracle SQL

INSTEAD OF Trigger | Oracle SQL

9
Comments
3 min read
Multithreading vs Multiprocessing

Multithreading vs Multiprocessing

Comments
1 min read
Trigger Complete Overview in Context of ORACLE SQL

Trigger Complete Overview in Context of ORACLE SQL

5
Comments
2 min read
Simple explanation of Clustered Index and Non-Clustered Index

Simple explanation of Clustered Index and Non-Clustered Index

Comments
1 min read
Clustered Index and Non-Clustered | Employee ID | Employee Name

Clustered Index and Non-Clustered | Employee ID | Employee Name

8
Comments
2 min read
Oracle SQL JSON operations

Oracle SQL JSON operations

Comments
3 min read
Top 5 JSON commands in SQL

Top 5 JSON commands in SQL

Comments
2 min read
Packages in Oracle SQL | Package specification | Package body

Packages in Oracle SQL | Package specification | Package body

Comments
1 min read
Dynamic SQL in Oracle | Complete Overview

Dynamic SQL in Oracle | Complete Overview

1
Comments
4 min read
DBMS_SQL package | Dynamic SQL

DBMS_SQL package | Dynamic SQL

1
Comments 1
3 min read
SUBSTR function in Oracle

SUBSTR function in Oracle

5
Comments
1 min read
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

9
Comments
2 min read
Bulk collect exceptions

Bulk collect exceptions

6
Comments
3 min read
Procedure vs Trigger

Procedure vs Trigger

Comments
2 min read
Static Site Generation (SSG) | Explanation with Anology

Static Site Generation (SSG) | Explanation with Anology

Comments
2 min read
20 Essential React concepts that every developer should know

20 Essential React concepts that every developer should know

11
Comments 1
3 min read
Analogy of Debouncing and Throttling:

Analogy of Debouncing and Throttling:

Comments
1 min read
Debouncing vs Throttling in React

Debouncing vs Throttling in React

Comments
2 min read
Analogy of Lazy loading and Memoization | React | Part 2

Analogy of Lazy loading and Memoization | React | Part 2

6
Comments
1 min read
Lazy loading and Memoization | ReactJS | Part 1

Lazy loading and Memoization | ReactJS | Part 1

Comments
2 min read
Multitasking and Parallelism with Analogy | PART 2

Multitasking and Parallelism with Analogy | PART 2

Comments
1 min read
Multitasking and parallelism | PART 1

Multitasking and parallelism | PART 1

Comments
1 min read
ORACLE vs postgress database Difference

ORACLE vs postgress database Difference

Comments
1 min read
SavePoint Best Explanation |

SavePoint Best Explanation |

5
Comments
2 min read
PLSQL BEST PART 2

PLSQL BEST PART 2

Comments
4 min read
PLSQL BEST PART 1

PLSQL BEST PART 1

Comments
4 min read
Working of SQL*Loader

Working of SQL*Loader

5
Comments
2 min read
Oracle Query Optimizer

Oracle Query Optimizer

Comments
3 min read
Query with PARALLEL and Without PARALLEL Execution

Query with PARALLEL and Without PARALLEL Execution

Comments
1 min read
Types of Materialized views

Types of Materialized views

5
Comments
4 min read
Most commonly used Oracle Hints Patterns

Most commonly used Oracle Hints Patterns

Comments
4 min read
EXPLAIN PLAN in more detail explanation

EXPLAIN PLAN in more detail explanation

Comments
5 min read
Detailed Explanation of DBMS PROFILER | Part 2

Detailed Explanation of DBMS PROFILER | Part 2

Comments
4 min read
Detailed Explanation of DBMS PROFILER with its Steps

Detailed Explanation of DBMS PROFILER with its Steps

5
Comments
4 min read
SQL*Loader in Oracle SQL

SQL*Loader in Oracle SQL

Comments
5 min read
Oracle Optimizer with Analogy Explanation

Oracle Optimizer with Analogy Explanation

Comments
3 min read
Oracle Optimizer

Oracle Optimizer

Comments
3 min read
Query hints in Oracle SQL

Query hints in Oracle SQL

5
Comments
1 min read
Query hints

Query hints

Comments
3 min read
Solution to a mutating trigger error in Oracle SQL

Solution to a mutating trigger error in Oracle SQL

Comments
2 min read
Analogy of mutating trigger with examples

Analogy of mutating trigger with examples

5
Comments
2 min read
Mutating trigger in Oracle SQL

Mutating trigger in Oracle SQL

5
Comments
2 min read
Compound Trigger in Oracle SQL

Compound Trigger in Oracle SQL

5
Comments
3 min read
ROWNUM vs ROW_NUMBER in Oracle

ROWNUM vs ROW_NUMBER in Oracle

Comments
3 min read
Pipelined Table Functions | ORACLE PLSQL | Best Explanation

Pipelined Table Functions | ORACLE PLSQL | Best Explanation

5
Comments
4 min read
loading...