Title: Demonstrate the use of character, number, and date functions in SELECT statements.
Course: Database Design and Management (Oracle) (10052) > Section: Performing Single-Row Functions

Demonstration of character functions should include the following:

- UPPER
- LOWER
- INITCAP
- CONCAT
- SUBSTR
- LENGTH
- INSTR
- LPAD
- TRIM
- CONCAT
- LENGTH

Demonstration of numeric functions (performing operations on numeric data) should include the following:

- ROUND
- TRUNC
- MOD

Demonstration of date functions (performing operations on date data) should include the following:

- SYSDATE
- +
- -
- /
- *
- MONTHS_BETWEEN
- ADD_MONTHS
- NEXT_DAY
- LAST_DAY
- ROUND
- TRUNC