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
Sur cette page du site, vous pouvez voir la vidéo en ligne SQL Single Row Functions | Numeric, Character, Date, Conversion & NULL Functions | Creative Notes durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Creative Notes 15 janvier 2026, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 29 fois et il a aimé 0 téléspectateurs. Bon visionnage!
