Oracle Cloud Infrastructure Documentation

Creating a Database Tools SQL Report

    1. Open the navigation menu and select Developer Services.
    2. 2. In the Database Tools section, select SQL Reports.
    3. In the SQL reports page, click Create SQL report.
    4. In the Create SQL report page, enter the following fields:
      • Name: Enter a user-friendly name for the report.
      • Description: Enter a description for the report.
      • Compartment: Select the compartment for the report.
      • Purpose: Describe what the report does and when to use it.
      • Instructions: Provide guidance for using this report.
      • SQL source: Enter the SQL code query that you want to use to generate the report. You can also load from file or from object storage.
      • Variables: Provide the name, data type, and description for each variable used by the report’s SQL source.
      • Columns: Provide the name, data type, and description for each column returned in the result set.
    5. Click Create.

  • Use the oci dbtools sql-report create-sql-report-oracle-database command to create a SQL Report. 

    oci dbtools sql-report create-sql-report-oracle-database 
--compartment-id <compartment_ocid> --display-name <display_name> --source <sql_query_or_file_path>

  • Use the DatabaseToolsSqlReport Reference API to create a SQL Report.