CONCATENATION USING ||
Use || to concatenate values. If one of the expressions in a concatenation is NULL, the result is NULL.
Syntax
string_expression ||'-' || string_expressionUse || to concatenate values. If one of the expressions in a concatenation is NULL, the result is NULL.
string_expression ||'-' || string_expression