Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for database servers.
Guide to SQL: TutorialThe HCL OneDB™ Guide to SQL: Tutorial shows how to use basic and advanced structured query language (SQL) to access and manipulate the data in your databases. It discusses the data manipulation language (DML) statements as well as triggers and stored procedure language (SPL) routines, which DML statements often use.
Functions in SELECT statements

Functions in SELECT statements

In addition to column names and operators, an expression can also include one or more functions. This chapter shows how to use functions in SELECT statements to perform more complex database queries and data manipulation.

For information about the syntax of the following SQL functions and other SQL functions, see the Expressions segment in the HCL OneDB™ Guide to SQL: Syntax.

Tip: You can also use functions that you create yourself. For information about user-defined functions, see Create and use SPL routines, and HCL OneDB User-Defined Routines and Data Types Developer's Guide.