Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Constant ExpressionsCertain expressions that return a fixed value are called constant expressions. These include variant function operators that read the system clock, but that are valid in contexts where literal constants are also valid.
Literal Collection

Literal Collection

HCL OneDB™ supports expressions that are literal representations of the values of built-in or user-defined collection data types. The following examples show literal collections as expressions:

INSERT INTO tab_a (set_col) VALUES ("SET{6, 9, 3, 12, 4}");

INSERT INTO TABLE(a_set) VALUES (9765);

UPDATE table1 SET set_col = "LIST{3}";

SELECT set_col FROM table1
   WHERE SET{17} IN (set_col);

For more information, see Literal Collection. For the syntax of element values, see Collection Constructors.