You can translate the question and the replies:

Convert CSV into rows without the use of SPLIT function

Hi experts, Looking for alternative ways of converting comma separated values into rows without using the SPLIT/FLATTEN function as we want to delegate this completely to an oracle source. Please let me know if any ideas. Thanks.
06-01-2021 16:06:31 -0500

1 Answer

Hi, I can think of the following ways as a possible solution for your requirement. 1. Using SELECT/UNION statement described in this article:[How to Pivot and Unpivot Views]( 2. You can try to create a base view from a query if you know the query that realizes your requirement in Oracle I found this info in the following manual. This should be helpful to you. * [Creating Base Views from SQL Queries]( Hope this helps!
Denodo Team
07-01-2021 02:08:55 -0500
You must sign in to add an answer. If you do not have an account, you can register here