DEV Community

# oracle

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
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!

8
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
Difference between GROUP BY and DISTINCT in SQL

Difference between GROUP BY and DISTINCT in SQL

1
Comments
1 min read
View vs Materialized View in Oracle SQL

View vs Materialized View in Oracle SQL

Comments
2 min read
Maximizing Performance: Best Practices for Database Scaling

Maximizing Performance: Best Practices for Database Scaling

1
Comments
16 min read
Aggregate function & Windows functions

Aggregate function & Windows functions

1
Comments
2 min read
Relationships in databases

Relationships in databases

7
Comments
2 min read
How to import excel into oracle only 1 step

How to import excel into oracle only 1 step

Comments
2 min read
loading...