DEV Community

mrcaption49 profile picture

mrcaption49

Oracle PLSQL Developer around 4 years of Experience in Database domain

Joined Joined on  Personal website https://linktr.ee/pranavbakare github website

Work

ORACLE PLSQL DEVELOPER at Nexsys IT

Pin Pinned

CURSOR in PLSQL | Best Explanation
mrcaption49 profile

CURSOR in PLSQL | Best Explanation

#beginners #programming #tutorial #sql
7
Comments 1
3 min read
Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger
mrcaption49 profile

Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger

#sql #database #fullstack #backend
6
Comments
2 min read
Pranav Bakare
mrcaption49 profile

Pranav Bakare

#devops #docker #ai #chatgpt
6
Comments
1 min read
Build your first CI/CD pipeline
mrcaption49 profile

Build your first CI/CD pipeline

#docker #kubernetes #cicd #githubactions
42
Comments 4
3 min read
Cron Job Basics
mrcaption49 profile

Cron Job Basics

#devops #cicd #docker #kubernetes
4
Comments
4 min read
Test VS CODE Snippet - CodeSnap
mrcaption49 profile

Test VS CODE Snippet - CodeSnap

Comments
1 min read

Want to connect with mrcaption49?

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

Create Account
Already have an account? Sign in
Automating Partition Cleanup in Oracle with PL/SQL and DBMS Scheduler
mrcaption49 profile

Automating Partition Cleanup in Oracle with PL/SQL and DBMS Scheduler

#opensource #data #datascience #database
5
Comments
4 min read
Automating Old Partition Cleanup in Oracle with PL/SQL
mrcaption49 profile

Automating Old Partition Cleanup in Oracle with PL/SQL

#automation #database #sql
6
Comments
3 min read
Audit Trigger for Tracking User Updates and Deletions in table
mrcaption49 profile

Audit Trigger for Tracking User Updates and Deletions in table

#oracle #programming #database #datascience
5
Comments
3 min read
mrcaption | PLSQL dev
mrcaption49 profile

mrcaption | PLSQL dev

5
Comments
2 min read
Resume Crafting Guide - PLSQL dev
mrcaption49 profile

Resume Crafting Guide - PLSQL dev

#oracle #data #database #datascience
5
Comments
4 min read
Oracle Performance Views
mrcaption49 profile

Oracle Performance Views

5
Comments
3 min read
Understanding Distributed Transaction Locks and Session-Specific Data in Oracle
mrcaption49 profile

Understanding Distributed Transaction Locks and Session-Specific Data in Oracle

#programming #database #oracle #backend
1
Comments
3 min read
Dynamic SQL
mrcaption49 profile

Dynamic SQL

Comments
2 min read
Understanding PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL: A Complete Guide
mrcaption49 profile

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

#database #data #datascience #dataengineering
5
Comments
3 min read
Materialized View with FAST REFRESH | Part 1 & Part 2
mrcaption49 profile

Materialized View with FAST REFRESH | Part 1 & Part 2

#data #programming #beginners #javascript
5
Comments
2 min read
ASH | AWR | ADDM in Oracle Database
mrcaption49 profile

ASH | AWR | ADDM in Oracle Database

#database #oracle #devops #datascience
5
Comments
2 min read
PRAGMA SERIALLY_REUSABLE in PL/SQL
mrcaption49 profile

PRAGMA SERIALLY_REUSABLE in PL/SQL

#machinelearning #database #datascience #data
5
Comments
4 min read
Audit Triggers + PRAGMA AUTONOMOUS_TRANSACTION
mrcaption49 profile

Audit Triggers + PRAGMA AUTONOMOUS_TRANSACTION

#programming #webdev #database #datascience
5
Comments
3 min read
PRAGMA INLINE in Oracle Database
mrcaption49 profile

PRAGMA INLINE in Oracle Database

#database #webdev #programming #data
Comments
3 min read
INSTEAD OF Triggers in Oracle
mrcaption49 profile

INSTEAD OF Triggers in Oracle

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

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

#ora
5
Comments
2 min read
Global Temporary Tables (GTT) in Oracle
mrcaption49 profile

Global Temporary Tables (GTT) in Oracle

#programming #ai #chatgpt #data
5
Comments
3 min read
Pseudocolumn in a database table
mrcaption49 profile

Pseudocolumn in a database table

#oracle #database #data #datascience
5
Comments
2 min read
Table Functions in Oracle PL/SQL | mrcaption49
mrcaption49 profile

Table Functions in Oracle PL/SQL | mrcaption49

7
Comments
4 min read
External Tables | File Management
mrcaption49 profile

External Tables | File Management

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

Creating Materialized View with FAST REFRESH | mrcaption49

#oracle #data #database #datascience
5
Comments
2 min read
Materialized Views in Oracle with Fast Refresh | mrcaption49
mrcaption49 profile

Materialized Views in Oracle with Fast Refresh | mrcaption49

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

PRAGMA SERIALLY_REUSABLE in Oracle PL/SQL | mrcaption49

#oracle #data #database #datascience
5
Comments
4 min read
AWS S3 Bucket
mrcaption49 profile

AWS S3 Bucket

#aws #cloud #devops #development
Comments
1 min read
NEXTVAL and CURRVAL in Oracle database
mrcaption49 profile

NEXTVAL and CURRVAL in Oracle database

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

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

#database #data #datascience #dataengineering
5
Comments
5 min read
UTL_FILE – Practical Guide | mrcaption49
mrcaption49 profile

UTL_FILE – Practical Guide | mrcaption49

5
Comments
4 min read
DBMS_SCHEDULER with Practical example | mrcaption49
mrcaption49 profile

DBMS_SCHEDULER with Practical example | mrcaption49

#database #data #datascience #dataengineering
5
Comments
4 min read
External Tables in Oracle Database complete Overview | mrcaption49
mrcaption49 profile

External Tables in Oracle Database complete Overview | mrcaption49

#oracle #database #data #datascience
5
Comments
4 min read
Data Dictionary Views in Oracle Database
mrcaption49 profile

Data Dictionary Views in Oracle Database

#oracle #data #database #datastructures
5
Comments
2 min read
DBMS_REDACT in Oracle Database
mrcaption49 profile

DBMS_REDACT in Oracle Database

#database #data #datascience #oracle
5
Comments
3 min read
Audit Tables + Triggers + Pragma Autonomous Transactions in Oracle | mrcaption49
mrcaption49 profile

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

#webdev #programming #oracle #data
5
Comments
4 min read
DBA_POLICIES in Oracle Database
mrcaption49 profile

DBA_POLICIES in Oracle Database

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

VPD | DBMS_RLS | Policy Function | FGAC

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

Virtual Private Database (VPD) and DBMS_RLS in Oracle

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

DBMS_RLS | Oracle VPD | Row-Level Security in Oracle

#oracle #data #database #datascience
5
Comments
3 min read
Oracle VPD (Virtual Private Database) along with Context Management
mrcaption49 profile

Oracle VPD (Virtual Private Database) along with Context Management

Comments
2 min read
DBMS context management
mrcaption49 profile

DBMS context management

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

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

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

Must-Have Visual Studio Code Extensions for Every Developer

#github #devops #development #fullstack
5
Comments
2 min read
DBMS_PROFILER in Oracle database
mrcaption49 profile

DBMS_PROFILER in Oracle database

#oracle #plsql #database #datascience
Comments
2 min read
DBMS_SCHEDULER in Oracle Database - Complete Guide
mrcaption49 profile

DBMS_SCHEDULER in Oracle Database - Complete Guide

#oracle #webdev #programming #data
5
Comments
3 min read
DBMS_SCHEDULER - CREATE_JOB | CREATE_PROGRAM | CREATE_SCHEDULE | mrcaption49
mrcaption49 profile

DBMS_SCHEDULER - CREATE_JOB | CREATE_PROGRAM | CREATE_SCHEDULE | mrcaption49

#oracle #programming #data #webdev
5
Comments
2 min read
Cursor and It's Types in Oracle Database
mrcaption49 profile

Cursor and It's Types in Oracle Database

1
Comments
2 min read
DBMS_SCHEDULER.CREATE_JOB in Oracle
mrcaption49 profile

DBMS_SCHEDULER.CREATE_JOB in Oracle

#opensource #chatgpt #programming #datascience
Comments
2 min read
Constraints and Indexes on Oracle Tables Using Data Dictionary Views
mrcaption49 profile

Constraints and Indexes on Oracle Tables Using Data Dictionary Views

Comments
2 min read
Foreign Keys in SQL
mrcaption49 profile

Foreign Keys in SQL

Comments
2 min read
Indexing In Oracle Database
mrcaption49 profile

Indexing In Oracle Database

Comments
1 min read
Audit Table with Trigger in Oracle Database
mrcaption49 profile

Audit Table with Trigger in Oracle Database

#oracle #database #datascience #programming
Comments
2 min read
Audit Tables in Oracle SQL Database
mrcaption49 profile

Audit Tables in Oracle SQL Database

#oracle #programming #database #datascience
Comments
2 min read
DBMS_SCHEDULER in ORACLE Database
mrcaption49 profile

DBMS_SCHEDULER in ORACLE Database

#oracle #database #data #programming
Comments
2 min read
External Tables in Oracle
mrcaption49 profile

External Tables in Oracle

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

TRIM vs RTRIM function in ORACLE SQL

#oracle #sql #data #database
Comments
1 min read
Data Dictionary Views (tables)
mrcaption49 profile

Data Dictionary Views (tables)

#sql #oracle #fullstack
Comments
2 min read
Security Trigger | D1
mrcaption49 profile

Security Trigger | D1

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

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

Comments
2 min read
Stale User session
mrcaption49 profile

Stale User session

Comments
2 min read
What is continuous integration (CI)
mrcaption49 profile

What is continuous integration (CI)

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

DevOps for Cloud Engineers....

Comments
2 min read
loading...