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?
- How to fix ora 01489 result of string concatenation is too long?
- How to solve ora 01861 literal does not match format string?
- How to resolve ora 12899 value too large for column?
- How to solve ora 01031 insufficient privileges in Oracle?
- How to solve ora 01722 invalid number?
- What is the concatenation operator in SQL?
- Why is a CD 74 minutes long?
- What will be the result of the following query: select concat first_name last_name as full_name from employees?
- Which SQL keyword can you use to combine the result set of two or more select statements?
- How do you limit the number of rows returned in a query result to 5?