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.
General functions
From the course: Oracle Database 19c: Basic SQL
General functions
- 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 general category single-row functions in this video and how they are used in the select statement or any sequel statement for that matter. To see how the general functions fit in with the rest, here's an overview. But they don't fit in very well, they're general and miscellaneous. This single-row functions fall into five basic categories, character, numeric, date and date arithmetic, conversion and general. Some of the general functions can possibly be assigned to one of the other categories because they have a similar return value, however many times they return abstract data types like XML or JSON or return sets so putting them all into this last category makes sense. Single-row functions return a single-rower column value for every row of the query. These functions can appear in five places, the select…
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)
-
-
-
-
-
-
-