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 NumberA literal number specifies a numeric value.

Literal Number

A literal number specifies a numeric value.

The following examples show literal numbers as expressions:

INSERT INTO items VALUES (4, 35, 52, 'HRO', 12, 4.00);

INSERT INTO acreage VALUES (4, 5.2e4);

SELECT unit_price + 5 FROM stock;

SELECT -1 * balance FROM accounts;

For more information, see Literal Number.