DEV Community

Pranav Bakare profile picture

Pranav Bakare

Oracle Full Stack Developer

Work

ORACLE PLSQL DEVELOPER at TCS

Types of Materialized views

Types of Materialized views

Comments
4 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
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

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

Comments
2 min read
Mutating trigger in Oracle SQL

Mutating trigger in Oracle SQL

Comments
2 min read
Compound Trigger in Oracle SQL

Compound Trigger in Oracle SQL

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

Comments
4 min read
Bulk Collect | Partitioning | Parallel Execution | Materialized Views | Dynamic SQL | Pipelined Table Functions | Large datasets

Bulk Collect | Partitioning | Parallel Execution | Materialized Views | Dynamic SQL | Pipelined Table Functions | Large datasets

Comments
4 min read
Types of constraints (primary key, foreign key, unique, check, and not null)

Types of constraints (primary key, foreign key, unique, check, and not null)

Comments
3 min read
USER_CONS_COLUMNS table | Constraints in SQL

USER_CONS_COLUMNS table | Constraints in SQL

Comments
1 min read
USER_CONSTRAINTS | Constraints in SQL

USER_CONSTRAINTS | Constraints in SQL

Comments
1 min read
OLAP (Online Analytical Processing)

OLAP (Online Analytical Processing)

9
Comments
3 min read
EXPLAIN PLAN & DBMS_PROFILER Explanation

EXPLAIN PLAN & DBMS_PROFILER Explanation

5
Comments
2 min read
Table functions and Pipelined functions in PLSQL | Best Explanation

Table functions and Pipelined functions in PLSQL | Best Explanation

5
Comments
2 min read
Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER

Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER

10
Comments
2 min read
EXPLAIN PLAN and DBMS_PROFILER

EXPLAIN PLAN and DBMS_PROFILER

5
Comments
2 min read
Kubernetes Basics | Get started with Kubernetes

Kubernetes Basics | Get started with Kubernetes

Comments
4 min read
Docker Compose vs Kubernetes

Docker Compose vs Kubernetes

11
Comments
3 min read
Docker | Docker Compose | Kubernetes

Docker | Docker Compose | Kubernetes

Comments
2 min read
Docker and Docker Compose

Docker and Docker Compose

Comments
2 min read
Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Interview Questions | 10 most important distinctions between concepts in Oracle SQL

Comments
2 min read
GROUP BY vs PARTITION BY in SQL

GROUP BY vs PARTITION BY in SQL

7
Comments
2 min read
Joins in ORACLE SQL

Joins in ORACLE SQL

Comments
2 min read
Key in Oracle SQL

Key in Oracle SQL

Comments
2 min read
Constraints in Oracle SQL

Constraints in Oracle SQL

Comments
2 min read
Best examples of Procedure in Oracle SQL

Best examples of Procedure in Oracle SQL

5
Comments
2 min read
PL/SQL Developer Interview Questions

PL/SQL Developer Interview Questions

Comments
5 min read
RefCursor without SYS_REFCURSOR declaration | RefCursor with SYS_REFCURSOR declaration

RefCursor without SYS_REFCURSOR declaration | RefCursor with SYS_REFCURSOR declaration

5
Comments
2 min read
Normal cursor Vs Ref cursor

Normal cursor Vs Ref cursor

Comments
1 min read
Normal Cursor and Ref Cursor

Normal Cursor and Ref Cursor

Comments
3 min read
Correlated subquery | Simplest Explanation

Correlated subquery | Simplest Explanation

5
Comments
1 min read
Subquery and Co-related subquery

Subquery and Co-related subquery

8
Comments
1 min read
SDLC | Waterfall model | Agile | DevOps

SDLC | Waterfall model | Agile | DevOps

Comments
3 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

9
Comments
3 min read
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER

5
Comments
3 min read
Query optimization techniques in Short | Best Explanation

Query optimization techniques in Short | Best Explanation

Comments
1 min read
What is Docker | In simple words

What is Docker | In simple words

Comments
2 min read
Infosys Portals career 2024

Infosys Portals career 2024

5
Comments
1 min read
PL/SQL Collections | Best Explanation

PL/SQL Collections | Best Explanation

5
Comments
5 min read
PL/SQL collections

PL/SQL collections

9
Comments
4 min read
BULK COLLECT in Oracle SQL | Best Explanation

BULK COLLECT in Oracle SQL | Best Explanation

10
Comments
4 min read
DBMS_SQL package | Dynamic SQL

DBMS_SQL package | Dynamic SQL

6
Comments
2 min read
Dynamic SQL in Oracle SQL | Best Explanation

Dynamic SQL in Oracle SQL | Best Explanation

8
Comments
4 min read
CTE | Common Table Expression | Real world scenarios examples

CTE | Common Table Expression | Real world scenarios examples

8
Comments 2
2 min read
SQL PLSQL | Most Important Concepts

SQL PLSQL | Most Important Concepts

6
Comments
3 min read
PL/SQL Developer with 3 years of experience | Interview Questions | Part 2

PL/SQL Developer with 3 years of experience | Interview Questions | Part 2

Comments
3 min read
PL/SQL Developer with 3 years of experience | Interview Questions | Part 1

PL/SQL Developer with 3 years of experience | Interview Questions | Part 1

Comments
4 min read
PL/SQL Developer Interview Questions with 3 years of experience

PL/SQL Developer Interview Questions with 3 years of experience

Comments
4 min read
Bind variables in Oracle SQL

Bind variables in Oracle SQL

8
Comments
2 min read
Pranav Bakare | PLSQL DEVELOPER

Pranav Bakare | PLSQL DEVELOPER

8
Comments
2 min read
Dynamic SQL in PL/SQL

Dynamic SQL in PL/SQL

11
Comments 1
2 min read
loading...