Posts in: Databases
Transactions
Understand what transactions are, why they matter in databases, and how Oracle ensures data consistency using transaction control.
Read More →COMMIT, ROLLBACK, SAVEPOINT
Use COMMIT, ROLLBACK, and SAVEPOINT to control the outcome of a transaction in Oracle SQL.
Read More →Locks & Deadlocks
Understand how locking works in Oracle SQL and how to avoid or resolve deadlocks in multi-user environments.
Read More →Analytical Functions
Learn how analytical functions in Oracle SQL allow complex calculations over a set of rows related to the current row without collapsing result sets.
Read More →RANK, DENSE_RANK, ROW_NUMBER
Use RANK, DENSE_RANK, and ROW_NUMBER to assign rankings or unique row numbers to result sets based on ordering criteria.
Read More →