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 ASSELECT C_IP,tab_to_string(CAST(COLLECT(WEB_LINK) AS T_VARCHAR2_TAB)) AS WEBLINKSFROM WEBLOG_SESSIONGROUP BY C_IP;
So when taking a table/file with only two columns into account, C_IP and WEB_LINK, you could consider that it's trying to remove duplicates from C_IP, and aggregating WEB_LINK data into a single row for each corresponding C_IP value. So, if you try to remove duplicates from the C_IP, there are around 1176 unique values, but can't do the same for WEB_LINK since the value is made up of urls.
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 ASSELECT C_IP,tab_to_string(CAST(COLLECT(WEB_LINK) AS T_VARCHAR2_TAB)) AS WEBLINKSFROM WEBLOG_SESSIONGROUP BY C_IP;
So when taking a table/file with only two columns into account, C_IP and WEB_LINK, you could consider that it's trying to remove duplicates from C_IP, and aggregating WEB_LINK data into a single row for each corresponding C_IP value. So, if you try to remove duplicates from the C_IP, there are around 1176 unique values, but can't do the same for WEB_LINK since the value is made up of urls.