Oracle Database 12c R2 SQL: Using Single-Row Functions to Customize Output Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/Description 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.
Expected Duration (hours)
1.2
Lesson 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
Course Number: it_dfosfd_12_enus
Expertise Level
Beginner