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

100 Oracle ACEs in 10 seconds

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

Should you EVER use the DROP COLUMN command?

The FASTEST way to unload data to CSV

The optimizer knows more about SQL than you

My THREE rules for SQL TUNING

A new feedback option in SQL Plus

Love JSON? Then youll love 19c!

How secure is your password ?

BOOLEAN arrives in the Database!

MEMORY_TARGET versus SGA_TARGET in 19c

SQL mastery with the PARTITIONED outer join

Stuff database people say - 1

Got a browser ? Then youve got Oracle Application Express!

How did YOU celebrate Pi day?

Strange observations with Interval partitions

Solve Sudoku with SQL! #sudoku

The BIGFILE ... why do we need it?

SQL101 - what is SECOND normal form? #shorts

Why UNION can kill your database performance

Seamless transition from PL/SQL to JSON in 23ai

Installing 23c/23ai FREE developer database ... in THREE steps

Application Express Upgrade ... so easy a cuddly toy can do it!!!

SQL Plus 18c rocks!

How to do READ WRITE operations on your READ ONLY database!

The KEEP clause will KEEP your SQL queries SIMPLE!

Faster problem solving in 23c/23ai !

Uh oh.... You dropped the wrong table. Now what?

How can I speed up a query if an index cannot help?

The SQL command line feature you never knew existed!

How to create a list partitioned table

The most common SQL mistakes!

How to partially index a table

Convert DBMS_OUTPUT to HTML

Creating Indexes on partitioned tables

SQL for pagination queries - memory and performance

How to audit every DDL command executed on the database

Testing database links without errors

Password Rollover for more security!

Private temporary tables

FREE training for Developers on Oracle Database

Dont stop that session ... just SUSPEND it

How does SELECT * FROM TABLE find its data? Back to basics with datafiles, segments and extents

How to get a row count for each table in the database

Check your dictionary for corruptions

Learn SQL Analytic functions in a FREE online course!

NOLOGGING ...Redo-ing your knowledge on Redo

SUBSTR is a SUBSTRING of SUBSTRING!

DBMS_METADATA ... ORA-01031: insufficient privileges?

The easiest, fastest APEX installation ever!

Oracle 21c on-premises release date

AskTOM TV - SQL trace, SQL plus, SQL developer