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
In questa pagina del sito puoi guardare il video online SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Creative Notes 15 gennaio 2026, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 29 volte e gli è piaciuto 0 spettatori. Buona visione!
