DEV Community

Pranav Bakare profile picture

Pranav Bakare

Oracle PLSQL Developer around 4 years of Experience in Database domain

Work

ORACLE PLSQL DEVELOPER at Nexsys IT

Dynamic SQL

Dynamic SQL

Comments
2 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
Understanding PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL: A Complete Guide

Understanding PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL: A Complete Guide

Comments
3 min read
Materialized View with FAST REFRESH | Part 1 & Part 2

Materialized View with FAST REFRESH | Part 1 & Part 2

5
Comments
2 min read
ASH | AWR | ADDM in Oracle Database

ASH | AWR | ADDM in Oracle Database

5
Comments
2 min read
PRAGMA SERIALLY_REUSABLE in PL/SQL

PRAGMA SERIALLY_REUSABLE in PL/SQL

5
Comments
4 min read
Audit Triggers + PRAGMA AUTONOMOUS_TRANSACTION

Audit Triggers + PRAGMA AUTONOMOUS_TRANSACTION

5
Comments
3 min read
PRAGMA INLINE in Oracle Database

PRAGMA INLINE in Oracle Database

Comments
3 min read
INSTEAD OF Triggers in Oracle

INSTEAD OF Triggers in Oracle

5
Comments
2 min read
Global Temporary Table (GTT) named session_transactions using the ON COMMIT PRESERVE ROWS

Global Temporary Table (GTT) named session_transactions using the ON COMMIT PRESERVE ROWS

5
Comments
2 min read
Global Temporary Tables (GTT) in Oracle

Global Temporary Tables (GTT) in Oracle

5
Comments
3 min read
Pseudocolumn in a database table

Pseudocolumn in a database table

5
Comments
2 min read
Table Functions in Oracle PL/SQL | mrcaption49

Table Functions in Oracle PL/SQL | mrcaption49

7
Comments
4 min read
External Tables | File Management

External Tables | File Management

5
Comments
3 min read
Creating Materialized View with FAST REFRESH | mrcaption49

Creating Materialized View with FAST REFRESH | mrcaption49

5
Comments
2 min read
Materialized Views in Oracle with Fast Refresh | mrcaption49

Materialized Views in Oracle with Fast Refresh | mrcaption49

5
Comments
5 min read
PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL | mrcaption49

PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL | mrcaption49

5
Comments
4 min read
AWS S3 Bucket

AWS S3 Bucket

Comments
1 min read
NEXTVAL and CURRVAL in Oracle database

NEXTVAL and CURRVAL in Oracle database

Comments
2 min read
Virtual Private Database (VPD) | DBMS_RLS | fine-grained access control (FGAC) | mrcaption49

Virtual Private Database (VPD) | DBMS_RLS | fine-grained access control (FGAC) | mrcaption49

5
Comments
5 min read
UTL_FILE – Practical Guide | mrcaption49

UTL_FILE – Practical Guide | mrcaption49

5
Comments
4 min read
DBMS_SCHEDULER with Practical example | mrcaption49

DBMS_SCHEDULER with Practical example | mrcaption49

5
Comments
4 min read
External Tables in Oracle Database complete Overview | mrcaption49

External Tables in Oracle Database complete Overview | mrcaption49

5
Comments
4 min read
Data Dictionary Views in Oracle Database

Data Dictionary Views in Oracle Database

5
Comments
2 min read
DBMS_REDACT in Oracle Database

DBMS_REDACT in Oracle Database

5
Comments
3 min read
Audit Tables + Triggers + Pragma Autonomous Transactions in Oracle | mrcaption49

Audit Tables + Triggers + Pragma Autonomous Transactions in Oracle | mrcaption49

5
Comments
4 min read
DBA_POLICIES in Oracle Database

DBA_POLICIES in Oracle Database

5
Comments
1 min read
VPD | DBMS_RLS | Policy Function | FGAC

VPD | DBMS_RLS | Policy Function | FGAC

5
Comments
1 min read
Virtual Private Database (VPD) and DBMS_RLS in Oracle

Virtual Private Database (VPD) and DBMS_RLS in Oracle

Comments
2 min read
DBMS_RLS | Oracle VPD | Row-Level Security in Oracle

DBMS_RLS | Oracle VPD | Row-Level Security in Oracle

5
Comments
3 min read
Oracle VPD (Virtual Private Database) along with Context Management

Oracle VPD (Virtual Private Database) along with Context Management

Comments
2 min read
DBMS context management

DBMS context management

Comments
2 min read
In-Database Archiving (IDA) | ORA_ARCHIVE_STATE in Oracle database

In-Database Archiving (IDA) | ORA_ARCHIVE_STATE in Oracle database

Comments
2 min read
Must-Have Visual Studio Code Extensions for Every Developer

Must-Have Visual Studio Code Extensions for Every Developer

5
Comments
2 min read
DBMS_PROFILER in Oracle database

DBMS_PROFILER in Oracle database

Comments
2 min read
DBMS_SCHEDULER in Oracle Database - Complete Guide

DBMS_SCHEDULER in Oracle Database - Complete Guide

5
Comments
3 min read
DBMS_SCHEDULER - CREATE_JOB | CREATE_PROGRAM | CREATE_SCHEDULE | mrcaption49

DBMS_SCHEDULER - CREATE_JOB | CREATE_PROGRAM | CREATE_SCHEDULE | mrcaption49

5
Comments
2 min read
Cursor and It's Types in Oracle Database

Cursor and It's Types in Oracle Database

1
Comments
2 min read
DBMS_SCHEDULER.CREATE_JOB in Oracle

DBMS_SCHEDULER.CREATE_JOB in Oracle

Comments
2 min read
Constraints and Indexes on Oracle Tables Using Data Dictionary Views

Constraints and Indexes on Oracle Tables Using Data Dictionary Views

Comments
2 min read
Foreign Keys in SQL

Foreign Keys in SQL

Comments
2 min read
Indexing In Oracle Database

Indexing In Oracle Database

Comments
1 min read
Audit Table with Trigger in Oracle Database

Audit Table with Trigger in Oracle Database

Comments
2 min read
Audit Tables in Oracle SQL Database

Audit Tables in Oracle SQL Database

Comments
2 min read
DBMS_SCHEDULER in ORACLE Database

DBMS_SCHEDULER in ORACLE Database

Comments
2 min read
External Tables in Oracle

External Tables in Oracle

5
Comments
4 min read
TRIM vs RTRIM function in ORACLE SQL

TRIM vs RTRIM function in ORACLE SQL

Comments
1 min read
Data Dictionary Views (tables)

Data Dictionary Views (tables)

Comments
2 min read
Security Trigger | D1

Security Trigger | D1

Comments
1 min read
Creation of a table | Primary key constraint | Sequence | Public synonyms with Grants

Creation of a table | Primary key constraint | Sequence | Public synonyms with Grants

Comments
2 min read
Stale User session

Stale User session

Comments
2 min read
What is continuous integration (CI)

What is continuous integration (CI)

Comments
7 min read
DevOps for Cloud Engineers....

DevOps for Cloud Engineers....

Comments
2 min read
Top 5 things that will help you during your Interview Process

Top 5 things that will help you during your Interview Process

1
Comments
2 min read
DB developer to QA to UAT

DB developer to QA to UAT

Comments
1 min read
NONPARTITIONED ONLINE in Oracle SQL

NONPARTITIONED ONLINE in Oracle SQL

Comments
1 min read
Cursor Attributes in PLSQL

Cursor Attributes in PLSQL

Comments
1 min read
AWS services and concepts

AWS services and concepts

1
Comments
2 min read
Security Triggers in PL/SQL

Security Triggers in PL/SQL

Comments
2 min read
Restore Points in Oracle SQL

Restore Points in Oracle SQL

Comments
2 min read
Liquibase, ChangeSet, and ChangeLog

Liquibase, ChangeSet, and ChangeLog

Comments
2 min read
loading...