Skip Headers
Previous
Previous
 
Next
Next

Concatenation Operator

The concatenation operator (||) combines text expressions.

Syntax

operand || operand

Example

'The date today is: ' || sysdate generates a text string such as The date today is: 23-AUG-06.

The next example concatenates the level name and dimension keys of the Product dimension to create an identifier.

PRODUCT.LEVEL_NAME || ' ' || PRODUCT.DIM_KEY

Level Dim Key Identifier
CLASS HRD CLASS HRD
FAMILY DTPC FAMILY DTPC
FAMILY MON FAMILY MON
FAMILY MEM FAMILY MEM
FAMILY MOD FAMILY MOD
FAMILY DISK FAMILY DISK
FAMILY LTPC FAMILY LTPC