154 тысяч подписчиков
835 видео
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
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?
MAX_STRING_SIZE ... bigger strings...bigger care needed.
SGA, PGA, help me with all these GA's
How to do READ WRITE operations on your READ ONLY database!
DML error logging - make your data loads more robust
Create your first 19c database on Windows
Avoiding never ending locks - expert mode
DML Error Logging - Weird Trigger Behaviour
Filling in missing dates in date ranges
SQL101 - The privileges developers will need
Back to Basics: Understanding Database Locking
SQL script execution times made easy!
Getting Ref Cursor output as CSV
