DEV Community

# oracle

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Normalization | 1 NF

Normalization | 1 NF

5
Comments
1 min read
Function-Based Index in SQL

Function-Based Index in SQL

1
Comments
3 min read
Database Design patterns in Oracle SQL

Database Design patterns in Oracle SQL

5
Comments 1
4 min read
Context Switching in PLSQL

Context Switching in PLSQL

2
Comments
2 min read
Deterministic Functions in PLSQL

Deterministic Functions in PLSQL

Comments
3 min read
Summary of Horizontal and Vertical Partitioning

Summary of Horizontal and Vertical Partitioning

4
Comments
2 min read
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

5
Comments
3 min read
Oracle 19c Benefits!

Oracle 19c Benefits!

9
Comments
2 min read
Interval Partitioning in Oracle SQL

Interval Partitioning in Oracle SQL

6
Comments
2 min read
Automatic Indexing in Oracle 19c version

Automatic Indexing in Oracle 19c version

5
Comments
2 min read
Exception Handling in PLSQL

Exception Handling in PLSQL

Comments
3 min read
Partition in Oracle | Revision49

Partition in Oracle | Revision49

Comments
2 min read
EXECUTE IMMEDIATE with BULK COLLECT

EXECUTE IMMEDIATE with BULK COLLECT

6
Comments
3 min read
EXECUTE IMMEDIATE in PL/SQL

EXECUTE IMMEDIATE in PL/SQL

6
Comments
2 min read
EXECUTE IMMEDIATE in Oracle SQL

EXECUTE IMMEDIATE in Oracle SQL

1
Comments
3 min read
CAP | ACID Properties| BASE in Database System

CAP | ACID Properties| BASE in Database System

5
Comments
2 min read
Multi-tenancy in Context of ORACLE

Multi-tenancy in Context of ORACLE

5
Comments
2 min read
The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

The Doctor's On-Call Shift example and a Normalized Relational Schema to Avoid Write Skew

2
Comments 3
7 min read
You Probably Don't Need Serializable Isolation

You Probably Don't Need Serializable Isolation

5
Comments
4 min read
A brief example of an SQL serializable transaction

A brief example of an SQL serializable transaction

25
Comments 10
7 min read
VARRAY (Variable-size array) in PL/SQL

VARRAY (Variable-size array) in PL/SQL

7
Comments
6 min read
VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND

VARRAY in PLSQL Functions | LIMIT | COUNT | EXTEND

5
Comments
2 min read
Difference between GROUP BY and DISTINCT in SQL

Difference between GROUP BY and DISTINCT in SQL

1
Comments
1 min read
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

6
Comments
3 min read
View vs Materialized View in Oracle SQL

View vs Materialized View in Oracle SQL

Comments
2 min read
loading...