Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output from Skillsoft

Online, Self-Paced

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.

Learning Objectives

Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output

identify the types of SQL functions in a SQL statement and describe single-row functions
use character functions in a SQL statement
use case conversion functions in a SQL statement
use character manipulation functions in a SQL statement
use nesting functions in a SQL statement
use 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 the SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
use arithmetic operators with dates in a SQL statement
use date manipulation functions such as MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, and LAST_DAY in a SQL statement
use the numeric ROUND and TRUNC functions with dates
write a SQL statements that use character, number, and date functions