This article provides details how to execute Oracle DB system tables from TIBCO Data Virtualization(TDV). 

How to execute Oracle DB system tables from TIBCO Data Virtualization?

All supported Operating Systems

This can be achieved by creating a TDV Packaged query. Follow below steps - 

Pre-requisites : An Oracle data source is already created in TDV. 
1. From Studio, create a packaged query for the Oracle data source. Right-click under /shared at your desired location > New > New Packaged Query. 
2. Select the Oracle data source and give the packaged query a name. Click OK. 

Screenshot for reference - 


3. Enter the SQL for the Oracle system table that you would like to execute query against. 
   Example:
     

 For  V$TIMEZONE_NAMES :  SQL : SELECT * FROM V$TIMEZONE_NAMES

  Save the packaged query. 

4. Navigate to the Parameters tab and click on "Design by examples" and select ok. Save the changes. 
5. Now, execute the packaged query to retrieve the results. 

Gif for reference -