Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output
Oracle SQL 12c
| Beginner
- 13 videos | 1h 10m 40s
- Includes Assessment
- Earns a Badge
Database tables may hold a large number of rows, which are often not sorted in any specific order. Discover how to selectively return only a subset of table rows, sorted and customized.
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 case conversion functions in a sql statementUse character manipulation functions in a sql statementUse nesting functions in a sql statementUse 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 the sysdate, current_date and current_timestamp functions in a sql statementUse arithmetic operators with dates in a sql statementUse date manipulation functions such as months_between, add_months, next_day, and last_day in a sql statementUse the numeric round and trunc functions with datesWrite a sql statements that use character, number, and date functions
IN THIS COURSE
-
5m 19sLearn how to identify the types of SQL functions in a SQL statement and describe how they work. FREE ACCESS
-
2m 12sLearn how to use character functions in SQL statements. FREE ACCESS
-
3m 29sIn this video, find out how to use case conversion functions in SQL statements. FREE ACCESS
-
9m 45sLearn how to use character manipulation functions in an SQL statement. FREE ACCESS
-
5m 5sIn this video, you will use nested functions in a SQL statement. FREE ACCESS
-
6m 47sIn this video, you will learn how to use the numeric ROUND and TRUNC functions in a SQL statement. FREE ACCESS
-
3m 29sTo find out how to use the MOD function in a SQL statement, consult a SQL reference guide or search for an online tutorial. FREE ACCESS
-
4m 54sIn this video, find out how to work with dates and the RR date format in SQL. FREE ACCESS
-
5m 27sIn this video, learn how to use the SYSDATE, CURRENT_DATE, and CURRENT_TIMESTAMP functions in a SQL statement. FREE ACCESS
-
3m 7sIn this video, you will use arithmetic operators with dates in SQL statements. FREE ACCESS
-
7m 16sIn this video, you will use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in an SQL statement. FREE ACCESS
-
4m 11sFind out how to use the numeric ROUND and TRUNC functions with dates. FREE ACCESS
-
9m 40sIn this video, you will learn how to write SQL statements that use character, 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.YOU MIGHT ALSO LIKE
Channel
Oracle RAC