Skip to main content

SQL: Custom Oracle Query

The Custom Query page for a Custom Oracle Query contains the same options as the Custom Query page for a custom SQL query, with the addition of the Convert CDB to DBA on non-container databases checkbox. It is a wizard page for the Custom Oracle Query category.

SQL Data Collector Wizard Custom Query page for a Custom Oracle Query

The configurable options are:

  • Test Database:

    • Data Source – Select the host\instance from the drop-down menu

    • Database – Select the database from the drop-down menu

      • Convert CDB to DBA on non-container databases

  • SQL Query textbox – Enter the custom SQL script

  • Validate Query – Click to test the query, results display in the box

  • Row limit – Enter a number to limit the rows the query is tested on