ViewTube

ViewTube
Sign inSign upSubscriptions
Filters

Upload date

Type

Duration

Sort by

Features

Reset

639 results

PLSQL Lab Notes
SQL BOSS: ADD_MONTHS vs + INTERVAL '1 month' (Oracle vs PostgreSQL)

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

0:37
SQL BOSS: ADD_MONTHS vs + INTERVAL '1 month' (Oracle vs PostgreSQL)

41 views

7d ago

PLSQL Lab Notes
Your First PL/SQL Block Explained (Oracle Beginner Tutorial)

Write and run your first PL/SQL block in Oracle: the four parts of a block, variables in the DECLARE section, printing with ...

3:00
Your First PL/SQL Block Explained (Oracle Beginner Tutorial)

32 views

2w ago

PLSQL Lab Notes
PL/SQL Procedures and Functions Explained for Beginners

Name your PL/SQL code and reuse it: create a procedure, create a function, use an OUT parameter, and learn to read compilation ...

2:06
PL/SQL Procedures and Functions Explained for Beginners

15 views

2w ago

PLSQL Lab Notes
PL/SQL Transactions: COMMIT, ROLLBACK and SAVEPOINT Explained

Keep your data consistent with PL/SQL transactions: a bank transfer that silently loses money, how SQL%ROWCOUNT and ...

2:32
PL/SQL Transactions: COMMIT, ROLLBACK and SAVEPOINT Explained

37 views

2w ago

PLSQL Lab Notes
PL/SQL IF, ELSIF and CASE Explained (Plus the NULL Trap)

Make decisions in PL/SQL with IF, ELSIF and CASE, and avoid the NULL trap that makes a condition quietly take the ELSE ...

2:23
PL/SQL IF, ELSIF and CASE Explained (Plus the NULL Trap)

20 views

2w ago

PLSQL Lab Notes
PL/SQL Packages Explained: Specification vs Body (Oracle)

Group related PL/SQL code into a package: write the specification and the body, keep a helper function private, call public code, ...

2:14
PL/SQL Packages Explained: Specification vs Body (Oracle)

23 views

2w ago

PLSQL Lab Notes
SQL BOSS #4: Which INSERT Raises ORA-04091?

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

0:41
SQL BOSS #4: Which INSERT Raises ORA-04091?

76 views

7d ago

Oracle Tech Hub
SQL SELECT Statement Explained! 🔥 | Learn SQL in Seconds

How to retrieve all columns using SELECT * - How to select specific columns - Simple SQL query examples #SQL #SQLTutorial ...

0:19
SQL SELECT Statement Explained! 🔥 | Learn SQL in Seconds

168 views

2w ago

PLSQL Lab Notes
PL/SQL BULK COLLECT and FORALL: Faster Loops (Real Timing)

Make PL/SQL loops faster with FORALL and BULK COLLECT: a real timing comparison of 50000 row-by-row inserts against one ...

2:21
PL/SQL BULK COLLECT and FORALL: Faster Loops (Real Timing)

58 views

2w ago

PLSQL Lab Notes
SQL BOSS #6: UPDATE SET a = b, b = a in MySQL

Boss puzzle: one row with a = 1 and b = 2, then UPDATE t SET a = b, b = a. Oracle and PostgreSQL swap the values. MySQL ...

0:45
SQL BOSS #6: UPDATE SET a = b, b = a in MySQL

28 views

7d ago

PLSQL Lab Notes
PL/SQL Error Backtrace: FORMAT_ERROR_BACKTRACE Explained

Find where an error really happened: SQLERRM tells you what, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE tells you ...

2:26
PL/SQL Error Backtrace: FORMAT_ERROR_BACKTRACE Explained

9 views

2w ago

PLSQL Lab Notes
PL/SQL Cursors Explained: OPEN, FETCH, CLOSE (Real Errors)

Understand PL/SQL cursors: the explicit cursor with OPEN, FETCH and CLOSE, the %NOTFOUND and %ROWCOUNT attributes, ...

2:24
PL/SQL Cursors Explained: OPEN, FETCH, CLOSE (Real Errors)

30 views

2w ago

PLSQL Lab Notes
PL/SQL Dynamic SQL: EXECUTE IMMEDIATE with Bind Variables

Run SQL built at run time with EXECUTE IMMEDIATE: DDL, a query with INTO and USING, a dynamic table name checked with ...

2:31
PL/SQL Dynamic SQL: EXECUTE IMMEDIATE with Bind Variables

12 views

2w ago

PLSQL Lab Notes
Oracle DBMS_SCHEDULER Tutorial: Run PL/SQL Automatically

Run PL/SQL on a timer with DBMS_SCHEDULER: create a job for a stored procedure, run it on demand, preview its next run ...

2:27
Oracle DBMS_SCHEDULER Tutorial: Run PL/SQL Automatically

53 views

13d ago

PLSQL Lab Notes
PL/SQL Exception Handling: NO_DATA_FOUND, TOO_MANY_ROWS, Custom

Handle errors in PL/SQL: a real ORA-01403 error, catching NO_DATA_FOUND and TOO_MANY_ROWS, raising your own ...

2:10
PL/SQL Exception Handling: NO_DATA_FOUND, TOO_MANY_ROWS, Custom

23 views

2w ago

PLSQL Lab Notes
SQL BOSS #1: ADD_MONTHS and the Last Day of the Month

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

0:39
SQL BOSS #1: ADD_MONTHS and the Last Day of the Month

45 views

8d ago

PLSQL Lab Notes
Oracle PIVOT and UNPIVOT: Rows to Columns and Back

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

2:49
Oracle PIVOT and UNPIVOT: Rows to Columns and Back

16 views

9d ago

Swamy Burry
New Batch SQL/PLSQL Started pls join if anyone interested #oracle #sql #plsql #training
0:30
New Batch SQL/PLSQL Started pls join if anyone interested #oracle #sql #plsql #training

1,066 views

3w ago

PLSQL Lab Notes
PL/SQL Loops Explained: FOR, WHILE and EXIT WHEN (Oracle)

Learn the PL/SQL loops: numeric FOR, WHILE, basic LOOP with EXIT WHEN, and the cursor FOR loop that walks through every ...

2:33
PL/SQL Loops Explained: FOR, WHILE and EXIT WHEN (Oracle)

14 views

2w ago

PLSQL Lab Notes
PL/SQL Collections: Associative Array, Nested Table, VARRAY

Hold many values in one variable: associative arrays with string keys, nested tables with EXTEND, VARRAYs with a fixed limit, ...

2:10
PL/SQL Collections: Associative Array, Nested Table, VARRAY

17 views

2w ago