Oracle Query to Vertica Query conversion
Posted: Thu Oct 20, 2016 6:58 am
Hi,
I am working on a DB migration project, in which the database is getting migrated from Oracle to Vertica, which also includes the conversion of PL/SQL procedures for vertica.(I am doing this in java with vertica SQL and JDBC).
One of the procedure is having a query like >>"select rtrim(xmlagg(xmlelement(e, group_desc||',')).extract('//text()'),',') from <table> where id in();" Do we have an equivalent function in vertica for xmlagg? or how this can be implemented in vertica?
I am working on a DB migration project, in which the database is getting migrated from Oracle to Vertica, which also includes the conversion of PL/SQL procedures for vertica.(I am doing this in java with vertica SQL and JDBC).
One of the procedure is having a query like >>"select rtrim(xmlagg(xmlelement(e, group_desc||',')).extract('//text()'),',') from <table> where id in();" Do we have an equivalent function in vertica for xmlagg? or how this can be implemented in vertica?