Purpose: CONCAT returns char1 concatenated with char2 The string returned is in the same character set as char1  Oracle Database returns the datatype that results in a lossless conversion. Lossless, as the name suggests, means a conversion that does not result in loss of data. if one of the arguments is a LOB, then the returned […]

CONCAT() Read More »