Customizing Output
Oracle 12c
| Beginner
- 13 Videos | 57m 7s
- Earns a Badge
In Oracle Database 12c, you have the ability to use functions to return and analyze data in a large variety of ways. Learn about character, case-conversion, numeric, nesting, date, and numeric functions.
WHAT YOU WILL LEARN
-
identify the types of SQL functions in a SQL statement and describe single-row functionsuse character functions in a SQL statementuse the case-conversion functions in a SQL statementuse the character-manipulation functions in a SQL statementuse the nesting functions in a SQL statementuse the numeric ROUND and TRUNC functions in a SQL statementuse the MOD function in a SQL statement
-
work with dates and the RR date format in a SQL statementuse SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statementuse arithmetic operators with dates in a SQL statementdescribe and use date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY in a SQL statementuse the numeric ROUND and TRUNC functions with dateswrite a SQL statement using the CHARACTER, NUMBER, and DATE functions
IN THIS COURSE
-
1.Types of SQL Functions and Single-Row Functions3m 57s
-
2.Character Functions2m 53s
-
3.Case-conversion Functions5m 46s
-
4.Character-manipulation Functions4m 38s
-
5.Nesting Functions5m 33s
-
6.Numeric ROUND and TRUNC Functions5m 51s
-
7.MOD Function2m 9s
-
8.Working with Dates and the RR Date Format3m 44s
-
9.SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP4m 14s
-
10.Arithmetic Operators in Dates3m 14s
-
11.Date-manipulation Functions and using Date Functions6m 8s
-
12.Numeric ROUND and TRUNC Functions with Dates2m 43s
-
13.Exercise: Use Character, Number, and Date Functions6m 19s
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.