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
En esta página del sitio puede ver el video en línea SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes de Duración hora minuto segunda en buena calidad , que subió el usuario Creative Notes 15 enero 2026, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 29 veces y le gustó 0 a los espectadores. Disfruta viendo!
