Home | Previous Page | Next Page

Using Functions in SELECT Statements

In This Chapter

Using Functions in SELECT Statements

Aggregate Functions

Using the COUNT Function

Using the AVG Function

Using the MAX and MIN Functions

Using the SUM Function

Using the RANGE Function

Using the STDEV Function

Using the VARIANCE Function

Applying Functions to Expressions

Using DAY and CURRENT Functions

Using the MONTH Function

Using the WEEKDAY Function

Using the YEAR Function

Formatting DATETIME Values

Date-Conversion Functions (IDS)

Using the DATE Function

Using the TO_CHAR Function

Using the TO_DATE Function

Cardinality Function (IDS)

Smart-Large-Object Functions (IDS)

String-Manipulation Functions (IDS)

Using the LOWER Function

Using the UPPER Function

Using the INITCAP Function

Using the REPLACE Function

Using the SUBSTRING and SUBSTR Functions

Using the SUBSTRING Function

Using the SUBSTR Function

Using the LPAD Function

Using the RPAD Function

Other Functions

Using the LENGTH Function

Using the USER Function

Using the TODAY Function

Using the DBSERVERNAME and SITENAME Functions

Using the HEX Function

Using the DBINFO Function

Using the DECODE Function

Using the NVL Function (IDS)

Using SPL Routines in SELECT Statements

Using Data Encryption Functions (IDS)

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]