ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

11 results

PLSQL Lab Notes
SQL Cinema 6: FOR UPDATE SKIP LOCKED. Which Seats Does B Get? (Oracle)

Three free seats, and session A holds seat 1 without a commit. Session B runs SELECT id FROM seats FOR UPDATE SKIP ...

0:32
SQL Cinema 6: FOR UPDATE SKIP LOCKED. Which Seats Does B Get? (Oracle)

22 views

8h ago

PLSQL Lab Notes
SQL Cinema 7: Consecutive Free Seats With id - ROW_NUMBER(). How Many Groups?

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

0:34
SQL Cinema 7: Consecutive Free Seats With id - ROW_NUMBER(). How Many Groups?

26 views

8h ago

PLSQL Lab Notes
SQL Cinema 5: FOR UPDATE NOWAIT on a Locked Seat. What Happens? (Oracle)

Session A updated seat 1 and did not commit. Session B runs SELECT ... FOR UPDATE NOWAIT on the same seat. NOWAIT ...

0:31
SQL Cinema 5: FOR UPDATE NOWAIT on a Locked Seat. What Happens? (Oracle)

14 views

8h ago

PLSQL Lab Notes
SQL Cinema 4: ORDER BY on Text Seats A1, A2, A10. What Order? (Oracle)

Seats are stored as text: A1, A2, A10. ORDER BY seat returns A1, A10, A2, because text is compared character by character and ...

0:34
SQL Cinema 4: ORDER BY on Text Seats A1, A2, A10. What Order? (Oracle)

42 views

8h ago

PLSQL Lab Notes
SQL Cinema 8: The Late Show Crosses Midnight. Which Date Does It End? (Oracle)

The late show starts at 23:30 on December 31, 2026 and runs two hours. TIMESTAMP '2026-12-31 23:30:00' + INTERVAL '2' ...

0:31
SQL Cinema 8: The Late Show Crosses Midnight. Which Date Does It End? (Oracle)

29 views

7h ago

PLSQL Lab Notes
SQL Cinema 9: Two Sessions Insert the Same UNIQUE Seat. What Happens to B? (Oracle)

Seat 7 has a UNIQUE constraint. Session A inserts it without a commit, then session B inserts the same seat. B waits. When A ...

0:36
SQL Cinema 9: Two Sessions Insert the Same UNIQUE Seat. What Happens to B? (Oracle)

1 view

7h ago

Select Tips From Dual
LIKE: wildcards, literally in Oracle SQL #shorts

... https://www.youtube.com/@SelectTipsFromDual?sub_confirmation=1 https://selecttipsfromdual.com #oracle #sql #plsql #like ...

0:42
LIKE: wildcards, literally in Oracle SQL #shorts

47 views

15h ago

Select Tips From Dual
GROUP BY: rows vs groups in Oracle SQL #shorts

... https://www.youtube.com/@SelectTipsFromDual?sub_confirmation=1 https://selecttipsfromdual.com #oracle #sql #plsql ...

0:42
GROUP BY: rows vs groups in Oracle SQL #shorts

85 views

15h ago

Select Tips From Dual
NOT IN: the NULL trap in Oracle SQL #shorts

... Written version + code: https://selecttipsfromdual.com/snippets/not-in-null-trap #oracle #sql #plsql #notin #shorts.

0:38
NOT IN: the NULL trap in Oracle SQL #shorts

65 views

14h ago

Select Tips From Dual
EXISTS vs IN: which one, when in Oracle SQL #shorts

... Written version + code: https://selecttipsfromdual.com/snippets/exists-vs-in #oracle #sql #plsql #existsvsin #shorts.

0:40
EXISTS vs IN: which one, when in Oracle SQL #shorts

116 views

14h ago

United Codes
The salary page your intern can open too | dbLinter A-1340

itemName=Grisselbav.dblinter #OracleAPEX #orclapex #PLSQL #SQL #OracleDatabase #dbLinter #Security #Shorts.

0:44
The salary page your intern can open too | dbLinter A-1340

29 views

15h ago