DEV Community

# oracle

Posts

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

24
Comments 9
7 min read
VARRAY (Variable-size array) in PL/SQL

VARRAY (Variable-size array) in PL/SQL

8
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
Aggregate function & Windows functions

Aggregate function & Windows functions

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

Maximizing Performance: Best Practices for Database Scaling

1
Comments
16 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
Exploring the New Features of Java 23

Exploring the New Features of Java 23

2
Comments 4
3 min read
Creating a backup table in ORACLE SQL

Creating a backup table in ORACLE SQL

7
Comments
1 min read
A Step-by-Step Approach to Implementing Oracle VMware in Your Organization

A Step-by-Step Approach to Implementing Oracle VMware in Your Organization

Comments
4 min read
Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3

Exception Handling in PL/SQL| PRAGMA EXCEPTION_INIT | Part 3

6
Comments
2 min read
How to install pterodactyl on oracle instance

How to install pterodactyl on oracle instance

4
Comments
9 min read
Procedure in PLSQL

Procedure in PLSQL

4
Comments
2 min read
%TYPE and %ROWTYPE Attributes in PLSQL

%TYPE and %ROWTYPE Attributes in PLSQL

6
Comments
2 min read
Difference between UNION and UNION ALL in SQL

Difference between UNION and UNION ALL in SQL

Comments
2 min read
Cursor in PLSQL - Best Explanation

Cursor in PLSQL - Best Explanation

Comments
2 min read
Cursor in PLSQL

Cursor in PLSQL

7
Comments
5 min read
Stored Procedure in PL/SQL

Stored Procedure in PL/SQL

2
Comments
2 min read
Common Table Expression (CTE) in PLSQL | Part 1

Common Table Expression (CTE) in PLSQL | Part 1

5
Comments
6 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

22
Comments
7 min read
loading...