Skip to content
Navigation menu
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
Context Switching in PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23 '24
Context Switching in PLSQL
#
interview
#
oracle
#
fullstack
#
devops
2
 reactions
Comments
Add Comment
2 min read
Deterministic Functions in PLSQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23 '24
Deterministic Functions in PLSQL
#
oracle
#
fullstack
#
devops
#
backend
Comments
Add Comment
3 min read
Summary of Horizontal and Vertical Partitioning
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23 '24
Summary of Horizontal and Vertical Partitioning
#
oracle
#
fullstack
#
web
#
backend
4
 reactions
Comments
Add Comment
2 min read
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23 '24
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning
#
oracle
#
fullstack
#
backend
#
database
5
 reactions
Comments
Add Comment
3 min read
Oracle 19c Benefits!
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22 '24
Oracle 19c Benefits!
#
oracle
#
data
#
database
#
fullstack
9
 reactions
Comments
Add Comment
2 min read
Interval Partitioning in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22 '24
Interval Partitioning in Oracle SQL
#
sql
#
oracle
#
beginners
#
programming
6
 reactions
Comments
Add Comment
2 min read
Automatic Indexing in Oracle 19c version
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 22 '24
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 '24
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 '24
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 '24
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 '24
EXECUTE IMMEDIATE in PL/SQL
#
plsql
#
oracle
#
backend
#
fullstack
6
 reactions
Comments
Add Comment
2 min read
EXECUTE IMMEDIATE in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21 '24
EXECUTE IMMEDIATE in Oracle SQL
#
opensource
#
oracle
#
fullstack
#
webdev
1
 reaction
Comments
Add Comment
3 min read
CAP | ACID Properties| BASE in Database System
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21 '24
CAP | ACID Properties| BASE in Database System
#
oracle
#
data
#
database
#
fullstack
5
 reactions
Comments
Add Comment
2 min read
Multi-tenancy in Context of ORACLE
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 21 '24
Multi-tenancy in Context of ORACLE
#
oracle
#
devops
#
fullstack
#
ai
5
 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
Oct 18 '24
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 '24
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 '24
A brief example of an SQL serializable transaction
#
yugabytedb
#
postgres
#
oracle
#
database
25
 reactions
Comments
13
 comments
7 min read
VARRAY (Variable-size array) in PL/SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 13 '24
VARRAY (Variable-size array) in PL/SQL
#
oracle
#
fullstack
#
data
#
database
7
 reactions
Comments
Add Comment
6 min read
VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 13 '24
VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND
#
sql
#
database
#
oracle
#
fullstack
5
 reactions
Comments
Add Comment
2 min read
Difference between GROUP BY and DISTINCT in SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12 '24
Difference between GROUP BY and DISTINCT in SQL
#
sql
#
database
#
oracle
#
fullstack
1
 reaction
Comments
Add Comment
1 min read
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12 '24
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING
#
beginners
#
sql
#
oracle
#
fullstack
6
 reactions
Comments
Add Comment
3 min read
View vs Materialized View in Oracle SQL
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12 '24
View vs Materialized View in Oracle SQL
#
oracle
#
fullstack
#
data
#
webdev
Comments
Add Comment
2 min read
Aggregate function & Windows functions
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 12 '24
Aggregate function & Windows functions
#
sql
#
database
#
oracle
#
fullstack
1
 reaction
Comments
Add Comment
2 min read
Maximizing Performance: Best Practices for Database Scaling
kaustubh yerkade
kaustubh yerkade
kaustubh yerkade
Follow
Oct 11 '24
Maximizing Performance: Best Practices for Database Scaling
#
database
#
oracle
#
mongodb
#
postgres
1
 reaction
Comments
Add Comment
16 min read
Relationships in databases
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 11 '24
Relationships in databases
#
sql
#
database
#
fullstack
#
oracle
7
 reactions
Comments
Add Comment
2 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account
