Single row functions in Oracle has following features.

• Returns one result per row.
• Used in SELECT, WHERE and ORDER BY clauses.
• Single row functions can be nested.

The single row functions can be further categorized as,

3.1.1.1 CHARACTER Functions

3.1.1.2 NUMBER Functions

3.1.1.3 DATE & TIME Functions

3.1.1.4 CONVERSION Functions