CS 450/550 Database Concepts

SQL String Functions

These functions can be used within sql or pl/sql statements. For example:

Functions Returning Strings

Character functions Returning Numeric Values

Miscellaneous Useful Functions

Checking Out Functions in SQLPlus

You can use SQLplus to see what the output from a function will be. The following use the tiny table named DUAL which has one row and one column and exists just for this purpose.
SQL> select to_char(0,'990.90') from dual;


SQL> select to_char(123456789,'990.90') from dual;