Oracle Programming/Using Single-Row Functions to Customize Output

From Wikibooks, open books for an open world
Jump to: navigation, search

Describing various types of functions available in SQL[edit]

  • Describe the differences between single row and multiple row functions

Single row functions return one result per row.

Single row functions:

 Manipulate data items
 Accept arguments and return one value
 Act on each row that is returned
 Return one result per row
 May modfy the data type
 Can be nested
 Accept arguments that cam be a column or an expression

Character functions

 Case manipulation functions
   LOWER
   UPPER
   INITCAP

Using character, number, and date functions in SELECT statements[edit]

  • 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