Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
#
oracle
Follow
Hide
Posts
Left menu
đź‘‹
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
Oracle Certified Java 8 Associate (OCA) Exam Preparation
Mercy
Mercy
Mercy
Follow
Nov 20
Oracle Certified Java 8 Associate (OCA) Exam Preparation
#
certification
#
java
#
oracle
#
beginners
6
 reactions
Comments
3
 comments
4 min read
Oracle Using Agile in ERP
Sharon Wang
Sharon Wang
Sharon Wang
Follow
Nov 20
Oracle Using Agile in ERP
#
oracle
#
erp
#
agile
#
projectmanage
Comments
1
 comment
5 min read
Mutating trigger in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 17
Mutating trigger in Oracle SQL
#
oracle
#
fullstack
#
devops
#
backend
Comments
Add Comment
2 min read
Compound Trigger in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 17
Compound Trigger in Oracle SQL
#
oracle
#
fullstack
#
database
#
data
Comments
Add Comment
3 min read
EXPLAIN PLAN & DBMS_PROFILER Explanation
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 16
EXPLAIN PLAN & DBMS_PROFILER Explanation
#
database
#
oracle
#
plsql
#
performance
5
 reactions
Comments
Add Comment
2 min read
ROLLUP
Cesar Castro
Cesar Castro
Cesar Castro
Follow
Nov 15
ROLLUP
#
sql
#
oracle
#
mysql
#
sqlserver
Comments
Add Comment
2 min read
Interview Questions | 10 most important distinctions between concepts in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 15
Interview Questions | 10 most important distinctions between concepts in Oracle SQL
#
oracle
#
fullstack
#
data
#
database
Comments
Add Comment
2 min read
PL/SQL Developer Interview Questions
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 14
PL/SQL Developer Interview Questions
#
interview
#
webdev
#
fullstack
#
oracle
Comments
Add Comment
5 min read
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 13
Top 10 advanced-level questions | ORACLE PLSQL DEVELOPER
#
oracle
#
fullstack
#
devops
#
database
5
 reactions
Comments
Add Comment
3 min read
Query optimization techniques in Short | Best Explanation
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 13
Query optimization techniques in Short | Best Explanation
#
fullstack
#
data
#
database
#
oracle
Comments
Add Comment
1 min read
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 13
On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL
#
sql
#
oracle
#
fullstack
#
backend
9
 reactions
Comments
Add Comment
3 min read
Table functions and Pipelined functions in PLSQL | Best Explanation
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 16
Table functions and Pipelined functions in PLSQL | Best Explanation
#
oracle
#
fullstack
#
backend
#
devops
5
 reactions
Comments
Add Comment
2 min read
Oracle Cloud HCM 24D Release: What’s New?
John Stein
John Stein
John Stein
Follow
Nov 11
Oracle Cloud HCM 24D Release: What’s New?
#
oracle
#
cloud
#
hcm
#
24d
Comments
Add Comment
5 min read
Collection and Record | Context of Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 8
Collection and Record | Context of Oracle SQL
#
plsql
#
oracle
#
fullstack
#
database
5
 reactions
Comments
Add Comment
2 min read
How to implement CREATE TABLE IF NOT EXISTS in Oracle
Andy
Andy
Andy
Follow
Oct 26
How to implement CREATE TABLE IF NOT EXISTS in Oracle
#
database
#
oracle
Comments
Add Comment
3 min read
Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 15
Analogy explaination of EXPLAIN PLAN and DBMS_PROFILER
#
oracle
#
fullstack
#
backend
#
devops
10
 reactions
Comments
Add Comment
2 min read
CTE | Common Table Expression | Real world scenarios examples
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 10
CTE | Common Table Expression | Real world scenarios examples
#
fullstack
#
backend
#
database
#
oracle
8
 reactions
Comments
2
 comments
2 min read
DBMS_SQL package | Dynamic SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 10
DBMS_SQL package | Dynamic SQL
#
fullstack
#
devops
#
oracle
#
opensource
6
 reactions
Comments
Add Comment
2 min read
Bind variables in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 9
Bind variables in Oracle SQL
#
oracle
#
webdev
#
programming
#
tutorial
8
 reactions
Comments
Add Comment
2 min read
Dynamic SQL in PL/SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 8
Dynamic SQL in PL/SQL
#
sql
#
oracle
#
database
#
backend
11
 reactions
Comments
1
 comment
2 min read
EXPLAIN PLAN and DBMS_PROFILER
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 15
EXPLAIN PLAN and DBMS_PROFILER
#
oracle
#
plsq
#
fullstack
#
backend
10
 reactions
Comments
Add Comment
2 min read
Dynamic SQL in Oracle SQL | Best Explanation
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 10
Dynamic SQL in Oracle SQL | Best Explanation
#
fullstack
#
database
#
backend
#
oracle
8
 reactions
Comments
Add Comment
4 min read
SQL PLSQL | Most Important Concepts
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 10
SQL PLSQL | Most Important Concepts
#
plsql
#
oracle
#
fullstack
#
backend
6
 reactions
Comments
Add Comment
3 min read
Pranav Bakare | PLSQL DEVELOPER
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Nov 8
Pranav Bakare | PLSQL DEVELOPER
#
devops
#
developer
#
fullstack
#
oracle
9
 reactions
Comments
Add Comment
2 min read
How to Document Your Database with a GUI Tool
Roxana Maria Haidiner
Roxana Maria Haidiner
Roxana Maria Haidiner
Follow
Nov 4
How to Document Your Database with a GUI Tool
#
database
#
mysql
#
postgres
#
oracle
Comments
3
 comments
8 min read
How to install pterodactyl on oracle instance
kokodev
kokodev
kokodev
Follow
Oct 1
How to install pterodactyl on oracle instance
#
pterodactyl
#
oracle
#
tutorial
2
 reactions
Comments
Add Comment
9 min read
Recuperar una Base de Datos Oracle Después de un Error en el Archivo spfile.ora
Ronal MejĂa
Ronal MejĂa
Ronal MejĂa
Follow
Oct 6
Recuperar una Base de Datos Oracle Después de un Error en el Archivo spfile.ora
#
oracle
#
database
Comments
Add Comment
3 min read
OCI Quota policy to limit vault count
Faris Durrani
Faris Durrani
Faris Durrani
Follow
Sep 28
OCI Quota policy to limit vault count
#
cloud
#
oracle
Comments
Add Comment
1 min read
The Rise of AI-Driven Oracle Managed Datacenters: What to Expect
Astute Marketing
Astute Marketing
Astute Marketing
Follow
Sep 27
The Rise of AI-Driven Oracle Managed Datacenters: What to Expect
#
datacenter
#
oracle
Comments
Add Comment
4 min read
Exploring the New Features of Java 23
Kailash Nirmal
Kailash Nirmal
Kailash Nirmal
Follow
Oct 10
Exploring the New Features of Java 23
#
java
#
jdk
#
oracle
#
jdk23
2
 reactions
Comments
4
 comments
3 min read
How to deploy an Apache web app using Oracle Cloud
Faris Durrani
Faris Durrani
Faris Durrani
Follow
Oct 30
How to deploy an Apache web app using Oracle Cloud
#
cloud
#
oracle
#
webdev
1
 reaction
Comments
Add Comment
3 min read
Oracle to Postgres : Happily Ever After edition
mayur
mayur
mayur
Follow
Oct 19
Oracle to Postgres : Happily Ever After edition
#
database
#
oracle
#
postgres
#
dbmigration
1
 reaction
Comments
Add Comment
10 min read
Listing compartments in OCI using Python
Faris Durrani
Faris Durrani
Faris Durrani
Follow
Sep 25
Listing compartments in OCI using Python
#
cloud
#
oracle
Comments
Add Comment
1 min read
Save money for OCI Instances by auto-shutting down outside of business hours
Faris Durrani
Faris Durrani
Faris Durrani
Follow
Sep 23
Save money for OCI Instances by auto-shutting down outside of business hours
#
cloud
#
oracle
Comments
Add Comment
2 min read
Interval Partitioning in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 24
Interval Partitioning in Oracle SQL
#
oracle
#
fullstack
#
devops
#
backend
5
 reactions
Comments
Add Comment
3 min read
Real-time examples of clustered and non-clustered indexes
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 24
Real-time examples of clustered and non-clustered indexes
#
oracle
#
plsql
#
data
#
100daysofcode
Comments
Add Comment
2 min read
Procedure vs Function | PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 24
Procedure vs Function | PLSQL
#
sql
#
devops
#
database
#
oracle
1
 reaction
Comments
Add Comment
2 min read
Oracle Enterprise Performance Management (EPM) September Updates 2024: What’s New?
John Stein
John Stein
John Stein
Follow
Sep 20
Oracle Enterprise Performance Management (EPM) September Updates 2024: What’s New?
#
oracle
#
enterprise
#
performance
#
management
Comments
Add Comment
3 min read
Normalisation | 2 NF
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Normalisation | 2 NF
#
sql
#
database
#
oracle
#
fullstack
5
 reactions
Comments
Add Comment
2 min read
Normalization | 1 NF
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Normalization | 1 NF
#
sql
#
database
#
oracle
#
fullstack
5
 reactions
Comments
Add Comment
1 min read
Function-Based Index in SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Function-Based Index in SQL
#
oracle
#
database
#
beginners
#
fullstack
1
 reaction
Comments
Add Comment
3 min read
Database Design patterns in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Database Design patterns in Oracle SQL
#
oracle
#
beginners
#
tutorial
#
programming
5
 reactions
Comments
1
 comment
4 min read
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning
#
oracle
#
fullstack
#
backend
#
database
6
 reactions
Comments
Add Comment
3 min read
Summary of Horizontal and Vertical Partitioning
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Summary of Horizontal and Vertical Partitioning
#
oracle
#
fullstack
#
web
#
backend
6
 reactions
Comments
Add Comment
2 min read
Deterministic Functions in PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Deterministic Functions in PLSQL
#
oracle
#
fullstack
#
devops
#
backend
Comments
Add Comment
3 min read
Context Switching in PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23
Context Switching in PLSQL
#
interview
#
oracle
#
fullstack
#
devops
Comments
Add Comment
2 min read
Oracle 19c Benefits!
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
Oracle 19c Benefits!
#
oracle
#
data
#
database
#
fullstack
10
 reactions
Comments
Add Comment
2 min read
Interval Partitioning in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
Interval Partitioning in Oracle SQL
#
sql
#
oracle
#
beginners
#
programming
5
 reactions
Comments
Add Comment
2 min read
Automatic Indexing in Oracle 19c version
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
Automatic Indexing in Oracle 19c version
#
machinelearning
#
ai
#
oracle
#
cloud
5
 reactions
Comments
Add Comment
2 min read
Exception Handling in PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
Exception Handling in PLSQL
#
webdev
#
programming
#
tutorial
#
oracle
Comments
Add Comment
3 min read
Partition in Oracle | Revision49
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
Partition in Oracle | Revision49
#
oracle
#
webdev
#
programming
#
beginners
Comments
Add Comment
2 min read
EXECUTE IMMEDIATE with BULK COLLECT
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
EXECUTE IMMEDIATE with BULK COLLECT
#
opensource
#
oracle
#
fullstack
#
backend
6
 reactions
Comments
Add Comment
3 min read
EXECUTE IMMEDIATE in PL/SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22
EXECUTE IMMEDIATE in PL/SQL
#
plsql
#
oracle
#
backend
#
fullstack
5
 reactions
Comments
Add Comment
2 min read
CAP | ACID Properties| BASE in Database System
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21
CAP | ACID Properties| BASE in Database System
#
oracle
#
data
#
database
#
fullstack
8
 reactions
Comments
Add Comment
2 min read
EXECUTE IMMEDIATE in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21
EXECUTE IMMEDIATE in Oracle SQL
#
opensource
#
oracle
#
fullstack
#
webdev
Comments
Add Comment
3 min read
Multi-tenancy in Context of ORACLE
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21
Multi-tenancy in Context of ORACLE
#
oracle
#
devops
#
fullstack
#
ai
8
 reactions
Comments
Add Comment
2 min read
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
YugabyteDB Distributed PostgreSQL Database
Oct 18
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew
#
yugabytedb
#
postgres
#
oracle
#
database
2
 reactions
Comments
3
 comments
7 min read
You Probably Don't Need Serializable Isolation
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
Oct 17
You Probably Don't Need Serializable Isolation
#
yugabytedb
#
postgres
#
oracle
#
database
5
 reactions
Comments
Add Comment
4 min read
A brief example of an SQL serializable transaction
Franck Pachot
Franck Pachot
Franck Pachot
Follow
for
AWS Heroes
Oct 11
A brief example of an SQL serializable transaction
#
yugabytedb
#
postgres
#
oracle
#
database
21
 reactions
Comments
9
 comments
7 min read
VARRAY (Variable-size array) in PL/SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 13
VARRAY (Variable-size array) in PL/SQL
#
oracle
#
fullstack
#
data
#
database
9
 reactions
Comments
Add Comment
6 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account