Oracle Programming/Using Single-Row Functions to Customize Output
From Wikibooks, open books for an open world
[edit] Describing various types of functions available in SQL
- Describe the differences between single row and multiple row functions
[edit] Using character, number, and date functions in SELECT statements
- Manipulate strings with character function in the SELECT and WHERE clauses
- Manipulate numbers with the ROUND, TRUNC and MOD functions
- Perform arithmetic with date data
- Manipulate dates with the date functions
