ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

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

27 views

8h ago

Baizeed Rony
Build a Banking System Using Oracle PL/SQL | Money Withdrawal Procedure Explained

🏦 **Build a Banking System Using Oracle PL/SQL | Money Withdrawal Procedure Explained in Bangla** Want to learn how Oracle PL ...

24:26
Build a Banking System Using Oracle PL/SQL | Money Withdrawal Procedure Explained

91 views

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

Select Tips From Dual
AND vs OR: parentheses, always in Oracle SQL #shorts

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

0:41
AND vs OR: parentheses, always in Oracle SQL #shorts

15 views

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

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

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

41 views

8h ago

Data Science With Dennis
Unlock PLSQL Mastery: The Book You Need to Get Started! #Shorts

Looking to master PLSQL? Here's the must-read book that'll kickstart your journey! Don't miss this solid recommendation!

0:41
Unlock PLSQL Mastery: The Book You Need to Get Started! #Shorts

18 views

4d ago

PLSQL Lab Notes
SQL Puzzle #15: Add 1 Month to Jan 31 in Oracle, PostgreSQL, MySQL

Adding one month to January 31 with INTERVAL. Oracle raises an error, because it builds February 31, which does not exist.

0:32
SQL Puzzle #15: Add 1 Month to Jan 31 in Oracle, PostgreSQL, MySQL

32 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

Durga Software Solutions
INDEPTH PL/SQL Online Training @ DURGASOFT

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

0:32
INDEPTH PL/SQL Online Training @ DURGASOFT

141 views

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

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

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