ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

138 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 BOSS: FETCH FIRST 2 ROWS WITH TIES. How Many Rows? (Oracle, PostgreSQL)

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

0:47
SQL BOSS: FETCH FIRST 2 ROWS WITH TIES. How Many Rows? (Oracle, PostgreSQL)

12 views

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

vlogommentary
How to Find the Max Date and Identify Its Source Field in PL/SQL

Learn an efficient method to determine the latest date from multiple date fields in PL/SQL and identify which field it belongs to for ...

2:44
How to Find the Max Date and Identify Its Source Field in PL/SQL

0 views

5d ago

PLSQL Lab Notes
SQL Puzzle: INSERT, CREATE TABLE, ROLLBACK. Is the Row Still There?

You insert a row, create another table, then roll back. In Oracle and MySQL a CREATE TABLE commits the open transaction first, ...

0:35
SQL Puzzle: INSERT, CREATE TABLE, ROLLBACK. Is the Row Still There?

14 views

6d ago

PLSQL Lab Notes
SQL BOSS #5: Sum of the Odd Numbers 1 to 99 in Oracle

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

0:35
SQL BOSS #5: Sum of the Odd Numbers 1 to 99 in Oracle

53 views

6d ago

PLSQL Lab Notes
SQL BOSS #9: BETWEEN With Timestamps (How Many Rows?)

Boss puzzle: three timestamps and BETWEEN '2026-01-01' AND '2026-01-31'. The end date means January 31 at midnight, ...

0:47
SQL BOSS #9: BETWEEN With Timestamps (How Many Rows?)

20 views

6d ago

PLSQL Lab Notes
SQL Cinema 1: SUM(price - discount) With a NULL Discount in Oracle

Three tickets cost 10 each. The discounts are 2, NULL and 2. SUM(price - discount) returns 16, not 26: price minus NULL is NULL, ...

0:33
SQL Cinema 1: SUM(price - discount) With a NULL Discount in Oracle

93 views

2d ago

PLSQL Lab Notes
SQL Cinema 3: Two Sessions Update the Same Seat. Who Waits? (Oracle)

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

0:33
SQL Cinema 3: Two Sessions Update the Same Seat. Who Waits? (Oracle)

25 views

2d 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)

24 views

7h ago

PLSQL Lab Notes
You Swiped Away. SQL Just Lost Your Row (Oracle NULL Trap)

Four viewers. Two swiped away, so their watch time is NULL. How many viewers did not watch exactly 30 seconds? Answer B: 1.

0:38
You Swiped Away. SQL Just Lost Your Row (Oracle NULL Trap)

26 views

6d ago

PLSQL Lab Notes
PLSQL Lab Notes: Real Oracle SQL, Real Errors (Channel Trailer)

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

0:31
PLSQL Lab Notes: Real Oracle SQL, Real Errors (Channel Trailer)

16 views

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

PLSQL Lab Notes
SQL Hard Puzzle: LEAD(n, 2, 0). What Is the Sum? (Window Functions)

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

0:40
SQL Hard Puzzle: LEAD(n, 2, 0). What Is the Sum? (Window Functions)

29 views

5d ago

Durga Software Solutions
INDEPTH PL/SQL Online Training @ DURGASOFT

INDEPTH PL/SQL Online Training @ DURGASOFT ==================================================== INDEPTH ...

0:32
INDEPTH PL/SQL Online Training @ DURGASOFT

142 views

1d ago

PLSQL Lab Notes
SQL Puzzle #20: Date Minus Date in Oracle, PostgreSQL, MySQL

DATE '2026-03-01' minus DATE '2026-02-01'. Oracle and PostgreSQL return 28 days. MySQL turns each date into a plain ...

0:36
SQL Puzzle #20: Date Minus Date in Oracle, PostgreSQL, MySQL

26 views

6d ago

PLSQL Lab Notes
SELECT Coffee #4: Pascal's Triangle With a Recursive Query: What Is Row 5?

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

0:36
SELECT Coffee #4: Pascal's Triangle With a Recursive Query: What Is Row 5?

54 views

4d ago

PLSQL Lab Notes
SQL Chess: Counting Captures in Morphy's Opera Game With SQL (Game Night 4)

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

0:34
SQL Chess: Counting Captures in Morphy's Opera Game With SQL (Game Night 4)

6 views

5d ago

PLSQL Lab Notes
SELECT Coffee 5: What Shape Does BITAND(n, k) = k Draw? (Oracle SQL)

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

0:33
SELECT Coffee 5: What Shape Does BITAND(n, k) = k Draw? (Oracle SQL)

13 views

2d ago