Course Logo

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;

TO_CHAR
-------
   0.00

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

TO_CHAR
-------
#######