ORA-01489

ORA-01489: result of string concatenation is too long Cause: String concatenation result is more than the maximum size. Action: Make sure that the result is less than the maximum size. Example: Problem Description: The problem with this query is with the use of CONCAT operator (||). e.g.: select char1 || char2 from dual Concat operator […]