Course details

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

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