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
-
3m 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
-
2m 53sIn this video, find out how to use character functions in SQL statements. FREE ACCESS
-
5m 46sIn this video, learn how to use the case-conversion functions in SQL statements. FREE ACCESS
-
4m 38sIn this video, find out how to use the character-manipulation functions in an SQL statement. FREE ACCESS
-
5m 33sIn this video, learn how to use the nesting functions in an SQL statement. FREE ACCESS
-
5m 51sDuring this video, you will learn how to use the numeric ROUND and TRUNC functions in SQL statements. FREE ACCESS
-
2m 9sDuring this video, you will learn how to use the MOD function in SQL statements. FREE ACCESS
-
3m 44sIn this video, learn how to work with dates and the RR date format in SQL statements. FREE ACCESS
-
4m 14sIn this video, find out how to use the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
-
3m 14sIn this video, find out how to use arithmetic operators with dates in a SQL statement. FREE ACCESS
-
6m 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
-
2m 43sDuring this video, you will learn how to use the numeric ROUND and TRUNC functions with date values. FREE ACCESS
-
6m 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.