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](https://community.denodo.com/kb/view/document/How%20to%20Pivot%20and%20Unpivot%20views)
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](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-sql-queries)
Hope this helps!