 |
Character Operators
Character strings are manipulated by character operators. The most common character operator is the concatenation operator. In the following example, two character strings are concatenated to form a new string.
SELECT EMPLOYEE NO IS EMPNO FROM EMP;
Sample Output:
EMPLOYEE NO IS 120003
If both strings have the data type char, the resulting string is char with a default length of 255 characters.
If either string is varchar2,, the resulting string is varchar2 with a default length of 200 characters. If one of the strings is null, the resulting string becomes equal to the non null string.
Domain Name Search
|
