How to solve ora 01489 result of string concatenation is too long?
You use a function that returns a CLOB, rather than a VARCHAR2. If you were ambitious, you could write your own function. However, the simplest way to do it is to use XMLAGG. It's a bit longer and not quite as pretty as listagg, but it's easier than writing your own function. Lees verder »
Bron: blog.tuningsql.com
How to resolve ora 01489 result of string concatenation is too long?
- Change OBJECT_NAME to the column you wish to comma-delimit.
- Modify OBJECT_ID to the expression you want to sort on.
- Also you'll have to change ', ' to whatever you want to delimit your list with.
- Lees verder »
Bron: blog.tuningsql.com
What is the maximum length of string concatenation in Oracle?
A string concatenation is a varchar2 -- hence, the max you can concat is 4000 bytes. Lees verder »
Bron: asktom.oracle.com
Gerelateerd aan How to solve ora 01489 result of string concatenation is too long?