mardi 4 août 2015

oracle sql cast a collection to another data type in sql statement

I have a collection of datasets that I need to convert into a string

 SELECT COLLECT (col1) FROM test_table;

does anyone know how to cast/convert the collection into a string in an sql statement?

Aucun commentaire:

Enregistrer un commentaire