Hello,
I tried using the LISTAGG function before, but since there is a likelihood that the output would be pretty long, maybe even more than 4000 bytes.. I kept getting the error that the result of string concatenation is too long. I followed AskTom page that Tim references about the [ implementation of a string aggregation function that returns a CLOB|http://asktom.oracle.com/pls/apex/f?p=100:11:0%3a%3a%3a%3aP11_QUESTION_ID:2196162600402#29842804516386] .
CREATE TABLE FINAL_LOG AS
SELECT SESSION_DT, C_IP, CS_USER_AGENT,
concat_all_ot(WEB_LINK, ' ')
WITHIN GROUP(ORDER BY C_IP, CS_USER_AGENT) AS "WEBLINKS"
FROM weblog_views
GROUP BY C_IP, CS_USER_AGENT, SESSION_DT
ORDER BY SESSION_DT
For this I get the following error,
SQL Error: ORA-00923: FROM keyword not found where expected
Can anyone tell me where I'm going wrong with this?