ViewTube

Procedures vs Functions: A First Look at PL/SQL - part 99 of Oracle SQL Zero to Hero: real SQL, explained line by line, in simple ...

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

Boss puzzle: Oracle ADD_MONTHS(DATE '2026-02-28', 1) versus PostgreSQL DATE '2026-02-28' + INTERVAL '1 month'.

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

Subscribe: https://www.youtube.com/@PLSQLLabNotes?sub_confirmation=1 #Shorts #SQL #Oracle #PLSQL.

Subscribe: https://www.youtube.com/@PLSQLLabNotes?sub_confirmation=1 #Shorts #SQL #Oracle #PLSQL.

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

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

Boss puzzle: what do these two ADD_MONTHS calls return? ADD_MONTHS(DATE '2026-01-31', 1) and ADD_MONTHS(DATE ...

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

In Oracle, MOD keeps the sign of the first number: MOD(-7, 3) returns -1. Answer C. Got it right? Follow for harder ones. Subscribe: ...

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

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

Turn rows into columns and back in Oracle: PIVOT with SUM, the old CASE approach, the hidden column trap that gives too many ...

UNION removes duplicates, so this query returns 2 rows. UNION ALL keeps them and would return 3. Answer A. Got it right?

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

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

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

Oracle rounds half away from zero: 3 and -3. Answer B. (Some languages round to even.) Follow for puzzle #6: SUBSTR with ...

The double pipe joins text in Oracle and PostgreSQL, so '1' || '1' returns 11. By default MySQL treats the double pipe as a logical ...