need help on how to use STRAGG function
585582Oct 7 2009 — edited Oct 7 2009Hi,
I am writing a sql query for reporting purposes using SYS_CONNECT_BY_PATH and it is breaking because of the below error.I searched and found that STRAGG function is the best one to be used for that.Can someone please give me the details of what I need to do.Like what the functions I need to create and how to use that in my query. the oracle version is 10.2.0.4
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.
Thanks.
Edited by: hyddba on Oct 7, 2009 2:51 PM