Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Oracle SQL 12c
| Beginner
- 13 Videos | 1h 6m 53s
- Includes Assessment
- Earns a Badge
Frequently when retrieving data stored in an Oracle database, the data needs to be converted, manipulated, or aggregated. Discover Oracle conversion functions and conditional expressions.
WHAT YOU WILL LEARN
-
describe the use of implicit and explicit data conversion within SQL statementsuse the TO_CHAR function to convert a date to a character data type in a SQL statementdemonstrate elements of the Date Format Model in SQLuse the TO_CHAR function to convert a number to a character data type in a SQL statementuse the TO_NUMBER and TO_DATE functions to convert a character data type to a number or date format in a SQL statementuse the TO_CHAR and TO_DATE functions with the RR date format to return data for a previous century in a SQL statementdescribe general functions when working with data and how it pertains to NULL values
-
use the NVL and NVL2 functions when working with NULL values in a SQL statementuse the NULLIF and COALESCE functions when working with NULL values in a SQL statement"describe conditional expressions to provide the use of the IF-THEN-ELSE logic in a SQL statement "use the CASE expression to facilitate a conditional inquiry in a SQL statementuse the DECODE function to facilitate conditional inquiry in a SQL statementapply conversions and conditional functions
IN THIS COURSE
-
1.Implicit and Explicit Data Type Conversion5m 44s
-
2.Use the TO_CHAR Function with Dates5m 22s
-
3.Date Format Model5m 51s
-
4.Use the TO_CHAR Function with Numbers5m 20s
-
5.TO_NUMBER and TO_DATE Functions5m 1s
-
6.Use TO_CHAR and TO_DATE with RR Date Format4m 38s
-
7.General Functions4m 20s
-
8.NVL and NVL2 Functions5m 22s
-
9.NULLIF and COALESCE Functions7m 21s
-
10.Conditional Expressions2m 6s
-
11.CASE Expression5m 18s
-
12.Using the DECODE Function3m 28s
-
13.Exercise: Apply Conversions7m 4s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.