OAS: Creating Dataset in Data Visualization using direct SQL that will union 2 tables results in no data
(Doc ID 2750332.1)
Last updated on FEBRUARY 10, 2021
Applies to:Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.
In Data Visualization, create a dataset using Direct SQL.
Note the dataset results shows no data. The same SQL however works and generated data in DB Client:
For example, SQL query used:
Steps to reproduce:
1. In Data Visualization, create a results set that uses direct SQL that will union 2 tables.
2. Note that no data is returned but same SQL generates results in the database client.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document