Data Conversion
Oracle 12c
| Beginner
- 13 Videos | 52m 45s
- Earns a Badge
Frequently when retrieving data stored in an Oracle database it needs to be converted, manipulated, or aggregated. Learn about the 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 statementdescribe elements of the Date Format Model in SQLuse the TO_CHAR Function to convert a number to a character datatype in a SQL statementUse the TO_NUMBER and TO_DATE function 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 pertaining to NULL values
-
use the NVL and NVL2 function when working with NULL values in a SQL statementuse the NULLIF and COALESCE functions when working with NULL values in a SQL statementuse conditional expressions to provide the use of the IF-THEN-ELSE logic in a SQL statementuse the CASE expression to facilitate a conditional inquiry in a SQL statementuse the DECODE function to facilitate conditional inquiry in a SQL statementwrite SQL statements using the TO_CHAR, TO_DATE, DECODE functions and the CASE Expression
IN THIS COURSE
-
1.Implicit and Explicit Data Type Conversion4m 23s
-
2.Using the TO_CHAR Function with Dates4m 6s
-
3.Date Format Model2m 52s
-
4.Using the TO_CHAR Function with Numbers5m 28s
-
5.TO_NUMBER and TO_DATE Functions3m 47s
-
6.Using TO_CHAR and TO_DATE with RR Date Format3m 27s
-
7.General Functions2m 42s
-
8.NVL and NVL2 Functions5m 43s
-
9.NULLIF and COALESCE Functions5m 26s
-
10.Conditional Expressions1m 52s
-
11.CASE Expression4m 51s
-
12.Using the DECODE Function3m 57s
-
13.Exercise: Use Functions and Conditional Expressions4m 11s
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.