From the course: Oracle Database 19c: Basic SQL
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Character functions returning character values
From the course: Oracle Database 19c: Basic SQL
Character functions returning character values
- [Narrator] Database single-row built-in functions can be divided into several categories; character, number, date, conversion, and the catch all general. I'll give a detailed overview of the first subset of character single-row functions in this video, the ones that specifically return character strings, and how they are used in the SELECT statement, or any SQL statement. To see how a character functions fit in with the rest, here's an overview of single-row functions. They fall into five basic categories; character, numeric, date, and date arithmetic, conversion, and general. Some of the conversion functions and general functions may technically fall into the number functions, only because they return a number, but we'll cover them in a different lesson. The Character functions can be broken down into two general subcategories; those character functions that manipulate character strings and return a modified or partial string such as sub-string. And the other category does some…
Contents
-
-
-
-
-
-
-
-
-
(Locked)
Numeric functions3m 12s
-
(Locked)
Character functions returning character values5m 16s
-
(Locked)
Character functions returning numeric values4m 53s
-
(Locked)
Datetime functions5m 12s
-
(Locked)
Conversion functions5m 26s
-
(Locked)
General functions3m 48s
-
(Locked)
Listing functions with SQL Developer2m 58s
-
(Locked)
-
-
-
-
-
-
-