Skip to content
Navigation menu
Search
Powered by
Search
Algolia
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
Normalization | 1 NF
Pranav Bakare
Pranav Bakare
Pranav Bakare
Follow
Oct 23 '24
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 '24
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 '24
Database Design patterns in Oracle SQL
#
oracle
#
beginners
#
tutorial
#
programming
5
reactions
Comments
1
comment
4 min read
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
10
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
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account