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