SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes
In this video, we explain Single Row Functions in Oracle SQL in a clear and practical way using real-time examples. Single row functions operate on each row individually and return one result per row, making them extremely important for SQL queries, interviews, and exams.
This tutorial covers numeric, character, date, conversion, and NULL handling functions with easy explanations and SQL queries.
👉🏻 Topics Covered in This Video:
Numeric Functions
Character (String) Functions
1. Case Conversion Functions (UPPER, LOWER, INITCAP)
2. Character Manipulation Functions (CONCAT, SUBSTR, LENGTH)
3. Whitespace Functions (TRIM, LTRIM, RTRIM)
4. Search Functions (INSTR)
5. Padding Functions
Date Functions
SYSDATE, CURRENT_DATE
MONTHS_BETWEEN
ADD_MONTHS
LAST_DAY
TRUNC
Date arithmetic with examples
Conversion Functions
Implicit vs Explicit Conversion
TO_CHAR (Date & Number formatting)
TO_DATE (Character / Number to Date)
TO_NUMBER
NULL & Conditional Functions
1. NVL
2. NVL2
3. NULLIF
4. COALESCE
5. DECODE
6. CASE Expression
👉 What you’ll learn in this SQL Tutorial :
00:00:00 – Introduction to SQL Functions
00:00:13 – Types of SQL Functions (Single Row vs Multiple Row)
00:01:24 – What are Single Row Functions?
00:01:47 – Classification of Single Row Functions
00:01:54 – Numeric Functions in SQL
00:05:02 – Character (String) Functions
00:08:46 – Date Functions
00:15:08 – Conversion Functions
00:16:41 – TO_CHAR Function
00:21:50 – TO_DATE Function
00:23:40 – TO_NUMBER Function
00:24:22 – General / NULL Handling Functions
#OracleSQL #SQLFunctions #SingleRowFunctions #LearnSQL #SQLTutorial #NVL #TO_CHAR #TO_DATE #SQLForBeginners #Database
Auf dieser Seite können Sie das Online-Video SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Creative Notes 15 Januar 2026 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 29 Mal angesehen und es wurde von 0 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
