Upload date
All time
Last hour
Today
This week
This month
This year
Type
All
Video
Channel
Playlist
Movie
Duration
Short (< 4 minutes)
Medium (4-20 minutes)
Long (> 20 minutes)
Sort by
Relevance
Rating
View count
Features
HD
Subtitles/CC
Creative Commons
3D
Live
4K
360°
VR180
HDR
138 results
Three free seats, and session A holds seat 1 without a commit. Session B runs SELECT id FROM seats FOR UPDATE SKIP ...
22 views
8h ago
10, 20, 20, 20, 30 with ORDER BY n DESC FETCH FIRST 2 ROWS WITH TIES returns 4 rows: 30 and all three 20s. Oracle and ...
12 views
5d ago
Free seats: 1, 2, 3, 5, 6 and 8. The expression id - ROW_NUMBER() OVER (ORDER BY id) gives 0, 0, 0, 1, 1, 2. Equal values ...
26 views
Seats are stored as text: A1, A2, A10. ORDER BY seat returns A1, A10, A2, because text is compared character by character and ...
42 views
Learn an efficient method to determine the latest date from multiple date fields in PL/SQL and identify which field it belongs to for ...
0 views
You insert a row, create another table, then roll back. In Oracle and MySQL a CREATE TABLE commits the open transaction first, ...
14 views
6d ago
Boss puzzle: add up the odd numbers from 1 to 99 with CONNECT BY LEVEL and MOD. There are 50 odd numbers, and the sum ...
53 views
Boss puzzle: three timestamps and BETWEEN '2026-01-01' AND '2026-01-31'. The end date means January 31 at midnight, ...
20 views
Three tickets cost 10 each. The discounts are 2, NULL and 2. SUM(price - discount) returns 16, not 26: price minus NULL is NULL, ...
93 views
2d ago
Session A updates a seat and does not commit. Session B updates the same row. In Oracle, B waits until A commits or rolls back: ...
25 views
The late show starts at 23:30 on December 31, 2026 and runs two hours. TIMESTAMP '2026-12-31 23:30:00' + INTERVAL '2' ...
24 views
7h ago
Four viewers. Two swiped away, so their watch time is NULL. How many viewers did not watch exactly 30 seconds? Answer B: 1.
PLSQL Lab Notes is a channel for real Oracle SQL, tested on a real database. Quick SQL puzzles (pick A, B or C before the timer ...
16 views
4d ago
Seat 7 has a UNIQUE constraint. Session A inserts it without a commit, then session B inserts the same seat. B waits. When A ...
1 view
LEAD looks two rows ahead and gives zero when there is no row. For 1, 2, 3, 4 the sum is 3 + 4 + 0 + 0 = 7. Window functions ...
29 views
INDEPTH PL/SQL Online Training @ DURGASOFT ==================================================== INDEPTH ...
142 views
1d ago
DATE '2026-03-01' minus DATE '2026-02-01'. Oracle and PostgreSQL return 28 days. MySQL turns each date into a plain ...
Pascal's triangle built with a recursive SQL query. Row 0 is 1, and each number is the sum of the two above it. Row 4 is 1, 4, 6, 4, ...
54 views
Morphy's Opera Game, 1858, has 33 half moves. A capture has an x in the notation, so LIKE '%x%' counts 12 captures, 6 by each ...
6 views
For each row n and column k, print a hash when BITAND(n, k) = k. The cells that print are exactly the odd numbers of Pascal's ...
13 views