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 functions
use character functions in a SQL statement
use the case-conversion functions in a SQL statement
use the character-manipulation functions in a SQL statement
use the nesting functions in a SQL statement
use the numeric ROUND and TRUNC functions in a SQL statement
use the MOD function in a SQL statement -
work with dates and the RR date format in a SQL statement
use SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
use arithmetic operators with dates in a SQL statement
describe and use date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY in a SQL statement
use the numeric ROUND and TRUNC functions with dates
write a SQL statement using the CHARACTER, NUMBER, and DATE functions
IN THIS COURSE
-
1. Types of SQL Functions and Single-Row Functions3m 57sIn this video, you will learn how to identify the types of SQL functions in a SQL statement and describe single-row functions. FREE ACCESS
-
2. Character Functions2m 53sIn this video, find out how to use character functions in SQL statements. FREE ACCESS
-
3. Case-conversion Functions5m 46sIn this video, learn how to use the case-conversion functions in SQL statements. FREE ACCESS
-
4. Character-manipulation Functions4m 38sIn this video, find out how to use the character-manipulation functions in an SQL statement. FREE ACCESS
-
5. Nesting Functions5m 33sIn this video, learn how to use the nesting functions in an SQL statement. FREE ACCESS
-
6. Numeric ROUND and TRUNC Functions5m 51sDuring this video, you will learn how to use the numeric ROUND and TRUNC functions in SQL statements. FREE ACCESS
-
7. MOD Function2m 9sDuring this video, you will learn how to use the MOD function in SQL statements. FREE ACCESS
-
8. Working with Dates and the RR Date Format3m 44sIn this video, learn how to work with dates and the RR date format in SQL statements. FREE ACCESS
-
9. SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP4m 14sIn this video, find out how to use the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
-
10. Arithmetic Operators in Dates3m 14sIn this video, find out how to use arithmetic operators with dates in a SQL statement. FREE ACCESS
-
11. Date-manipulation Functions and using Date Functions6m 8sAfter completing this video, you will be able to describe and use the date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statement. FREE ACCESS
-
12. Numeric ROUND and TRUNC Functions with Dates2m 43sDuring this video, you will learn how to use the numeric ROUND and TRUNC functions with date values. FREE ACCESS
-
13. Exercise: Use Character, Number, and Date Functions6m 19sIn this video, you will learn how to write a SQL statement using the CHAR, NUMBER, and DATE functions. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
