Character Operators

Character operators are used in the expressions to manipulate character strings. A Concatenation operator (||) is used to perform this operation.

Example

SELECT ‘This is an ‘|| ’Example for ‘|| ‘Concatenation operator’ FROM DUAL; Displays, THIS IS AN EXAMPLE FOR CONCATENATION OPERATOR
----------------------------------------------
Output: This is an Example for Concatenation operator

In the given example, a system table known as ‘DUAL’ is used. This table holds one column.The result of concatenating three character strings is another character string. If all the strings are of character datatyp and, the resultant also holds the character datatype, is restricted to 255 characters.