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?
- What does ORDER BY 1 2 3 mean in SQL?
- Which operator is used to concatenate or join two or more settings?
- Which function is used to concatenate two or more strings?
- Which SQL command is used to add a row to the customers table with customer_id, name, and address columns?
- Which operator can be used to concatenate strings?
- What is the concat keyword in SQL?
- What will be the result of the following query: select concat first_name last_name as full_name from employees?
- How to fix deadlock issue in Oracle?