Oracle Programming/Using Single-Row Functions to Customize Output

< Oracle Programming

Describing various types of functions available in SQLEdit

  • 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 modify the data type
 Can be nested
 Accept arguments that can be a column or an expression

Character functions

 Case manipulation functions

SELECT LOWER(column_name) FROM table_name;


SELECT UPPEFR(column_name) FROM table_name;


SELECT INITCAP(column_name) FROM table_name;

Using character, number, and date functions in SELECT statementsEdit

  • 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