I've got an excel file with columns,
C_IP
SESSION_ID
CS_USER_AGENT
CS_URI_STEM
CS_URI_QUERY
WEB_LINK
I'm not able to aggregate the above attributes due to the limitations of the string size allowed in Oracle (11g). I tried to use a user-defined aggregating function for this. I want to aggregate the "WEB_LINK" column, and group by C_IP. Is it possible to do this in Excel?
The SQL query I tried to use was,
CREATE TABLE WEBLOG_AGG AS
SELECT C_IP,
tab_to_string(CAST(COLLECT(WEB_LINK) AS T_VARCHAR2_TAB)) AS WEBLINKS
FROM WEBLOG_SESSION
GROUP BY C_IP;
Cross-posts:
http://www.mrexcel.com/forum/excel-q...ml#post3345639
http://stackoverflow.com/users/18885...?tab=questions
http://www.excelguru.ca/forums/showt...=5973#post5973
Bookmarks