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
Nesta página do site você pode assistir ao vídeo on-line SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Creative Notes 15 Janeiro 2026, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 29 vezes e gostou 0 espectadores. Boa visualização!
