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
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
