Concatenation Operator

Data Types and SubtypesData Definition (DDL) Statements

Concatenation Operator

The concatenation operator — two pipe characters known as “double pipe” or ‘||’ — concatenates two character strings to form a single string.Character strings can be literals or values obtained from columns or other expressions.

Example

SELECT LAST_NAME || ', ' || FIRST_NAME AS FULL_NAME
FROM EMPLOYEE

Arithmetic Operators

Table 1. Arithmetic Operator Precedence
Operator	Purpose	Precedence
`+signed_number`	Unary plus	1
`-signed_number`	Unary minus	1
`*`	Multiplication	2
`/`	Division	2
`+`	Addition	3
`-`	Subtraction	3

Example

UPDATE T
    SET A = 4 + 1/(B-C)*D

Note	Where operators have the same precedence, they are evaluated in left-to-right sequence.