SQL and Database explained!

Which rows are locked in my database?

Primary Key options for Partitioned Tables

How Wait Events work in the Multi-tenant world

Frustration with tech documentation?

Speeding up Database Constraints

The BEST way to FETCH from the database

The mysterious KEEP clause in SQL

Oracle ACE - The Community For You!

Selfies at CloudWorld

Welcome to CloudWorld - the Oracle ACE program

Take a fresh look at Edition Based Redefinition

1 million rows/second is the WORST to expect

AskTOM TV - SQL trace, SQL plus, SQL developer

Performance Problems with Format Masks

Oracle 12c Release 2 - How to move a heap table online

12 new LOOP features in PL/SQL for cleaner, tighter code

Cool features with NESTED TABLES and ARRAYS in PLSQL

Horror Stories - Do not get fired over this mistake!

HUGE news on PLUGGABLE database!

ROLLUP supercharges your GROUP BY queries!

skip_unusable_indexes is NOT skipping unusable indexes!

Why the WITH clause is awesome in SQL

How to remove duplicates quickly and easily

NOT NULL ... Do CHECK CONSTRAINTS matter ?

smtp_out_server and sending mail from the database

The best collection of FREE database tools

18c XE - the hidden catch

Finding problem SQL - a deep dive into internals

How to read the LONG columns with SQL

Pipelined Functions - an important fix!

How to never lose data with your Standby Database

The UTC timezone. Why SYSDATE might be wrong for you

Convert columns to rows easily with UNPIVOT

How to install Oracle Database 21c software on Linux

The Database Optimizer is smarter than you!

Recover a database with JUST the datafiles?

A peek at bind variable peeking

Partitioning on Multiple columns

Standard Edition is so much more than "standard"

SQL Macros with no SQL Injection !

SQL for pagination queries - advanced options

Understanding the Flashback Log files

SQL101 - How to connect to the database

Analytics: 14 NTH_VALUE in windows

What makes a GOOD database trigger?

How to get gap free sequence numbers

Run OS commands from the database!

Beginner's Guide - Installing 23ai on Oracle Linux 9

What is a Direct path read?

Validity checks on SQL

A rethink on rebuilding indexes

Why a Sequence gives duplicate values!

Why do we need Private Temporary Tables?

Querying partitioned tables efficiently

19c Database installation on Linux

Special use cases for partitioned tables