Question

character for concentrarion of strings

Answer 1

If both character strings are of datatype CHAR , the result has datatype CHAR and is limited to 2000characters. If either string is of datatype VARCHAR2 , the result has datatype VARCHAR2 and is limited to 4000 characters. If either argument is a CLOB , the result is a temporary CLOB .