DEV Community

# oracle

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to implement CREATE TABLE IF NOT EXISTS in Oracle

How to implement CREATE TABLE IF NOT EXISTS in Oracle

5
Comments
3 min read
Interval Partitioning in Oracle SQL

Interval Partitioning in Oracle SQL

5
Comments
3 min read
Real-time examples of clustered and non-clustered indexes

Real-time examples of clustered and non-clustered indexes

Comments
2 min read
Oracle Enterprise Performance Management (EPM) September Updates 2024: What’s New?

Oracle Enterprise Performance Management (EPM) September Updates 2024: What’s New?

Comments
3 min read
Normalisation | 2 NF

Normalisation | 2 NF

5
Comments
2 min read
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

1
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!

7
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
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
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

3
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

26
Comments 13
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
RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

RAISE_APPLICATION_ERROR and PRAGMA EXCEPTION_INIT in PLSQL EXCEPT HANDLING

7
Comments 1
3 min read
loading...