ViewTube

In this lesson, we explore Oracle SQL analytical functions LAG and LEAD and how they work with the OVER clause to access ...

In this lesson, we introduce Single Row Functions, also known as scalar functions in SQL. Single row functions process data row ...

In this lesson, we explore nesting SQL functions and why combining functions is essential for real-world data manipulation.

In this lesson, we learn how to concatenate strings in Oracle SQL using different approaches. You'll see how to combine columns, ...

In this lesson, we explore the SOUNDEX function in Oracle SQL, which allows you to find words that sound similar, even if they ...

In this lesson, we explore how to remove unwanted characters from strings in Oracle SQL using trimming functions like RTRIM, ...

In this quick lesson, we cover how to measure the length of a string in Oracle SQL using the LENGTH function. It's simple, fast, and ...

In this lesson, we learn how to extract parts of a string in Oracle SQL using the SUBSTR function. What you'll learn: How ...

In this lesson, we explore the INITCAP character function in SQL. This function formats text by converting the first letter of each ...

In this lesson, we explore text padding in Oracle SQL using the LPAD and RPAD functions. You'll learn how to format output by ...

In this lesson, we cover the most important numerical functions in Oracle SQL, used for calculations, rounding, and numeric ...

In this lesson, we explore Oracle SQL date functions and how to work with dates, times, and intervals. ⏱ What you'll learn: Getting ...

In this lesson, we learn how to search for text inside a string in Oracle SQL using the INSTR function. It helps you find the exact ...

In this lesson, we learn how to use the UPPER and LOWER character functions in SQL. These functions convert text to uppercase ...

In this lesson, we take a quick look at additional Oracle SQL analytical functions commonly used in reporting and data analysis.

In this lesson, we introduce SQL data type conversions and explain how Oracle converts values between numbers, text, and dates ...

In this lesson, we dive into Oracle SQL analytical functions and learn how to calculate running totals and window-based ...

In this lesson, we cover the TO_CHAR function and how to convert numbers and character data into formatted text in Oracle SQL.

In this lesson, we explore the TO_NUMBER function and how to safely convert text values into numbers in Oracle SQL. What ...

In this lesson, we explore how to use TO_CHAR to convert dates into formatted text in Oracle SQL. What you'll learn: ...