Sign in Dashboard Get started
  1. Packages
  2. Packages
  3. Oracle Cloud Infrastructure
  4. API Docs
  5. DatabaseTools
  6. getDatabaseToolsSqlReports
Viewing docs for Oracle Cloud Infrastructure v4.13.0
published on Thursday, May 28, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

oci.DatabaseTools.getDatabaseToolsSqlReports

oci logo
Viewing docs for Oracle Cloud Infrastructure v4.13.0
published on Thursday, May 28, 2026 by Pulumi
Schema (JSON)
pulumi/pulumi-oci

    This data source provides the list of Database Tools Sql Reports in Oracle Cloud Infrastructure Database Tools service.

    Returns a list of Database Tools SQL reports.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDatabaseToolsSqlReports = oci.databasetools.getDatabaseToolsSqlReports({
    compartmentId: compartmentId,
    displayName: databaseToolsSqlReportDisplayName,
    state: databaseToolsSqlReportState,
    types: databaseToolsSqlReportType,
});

    import pulumi
import pulumi_oci as oci

test_database_tools_sql_reports = oci.databasetools.get_database_tools_sql_reports(compartment_id=compartment_id,
    display_name=database_tools_sql_report_display_name,
    state=database_tools_sql_report_state,
    types=database_tools_sql_report_type)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v4/go/oci/databasetools"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasetools.GetDatabaseToolsSqlReports(ctx, &databasetools.GetDatabaseToolsSqlReportsArgs{
			CompartmentId: compartmentId,
			DisplayName:   pulumi.StringRef(databaseToolsSqlReportDisplayName),
			State:         pulumi.StringRef(databaseToolsSqlReportState),
			Types:         pulumi.ToArray(databaseToolsSqlReportType),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

    using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDatabaseToolsSqlReports = Oci.DatabaseTools.GetDatabaseToolsSqlReports.Invoke(new()
    {
        CompartmentId = compartmentId,
        DisplayName = databaseToolsSqlReportDisplayName,
        State = databaseToolsSqlReportState,
        Types = databaseToolsSqlReportType,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsFunctions;
import com.pulumi.oci.DatabaseTools.inputs.GetDatabaseToolsSqlReportsArgs;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;

public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }

    public static void stack(Context ctx) {
        final var testDatabaseToolsSqlReports = DatabaseToolsFunctions.getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs.builder()
            .compartmentId(compartmentId)
            .displayName(databaseToolsSqlReportDisplayName)
            .state(databaseToolsSqlReportState)
            .types(databaseToolsSqlReportType)
            .build());

    }
}

    variables:
  testDatabaseToolsSqlReports:
    fn::invoke:
      function: oci:DatabaseTools:getDatabaseToolsSqlReports
      arguments:
        compartmentId: ${compartmentId}
        displayName: ${databaseToolsSqlReportDisplayName}
        state: ${databaseToolsSqlReportState}
        types: ${databaseToolsSqlReportType}

    pulumi {
  required_providers {
    oci = {
      source = "pulumi/oci"
    }
  }
}

data "oci_databasetools_getdatabasetoolssqlreports" "testDatabaseToolsSqlReports" {
  compartment_id = compartmentId
  display_name   = databaseToolsSqlReportDisplayName
  state          = databaseToolsSqlReportState
  types          = databaseToolsSqlReportType
}

    Using getDatabaseToolsSqlReports

    Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.

    function getDatabaseToolsSqlReports(args: GetDatabaseToolsSqlReportsArgs, opts?: InvokeOptions): Promise<GetDatabaseToolsSqlReportsResult>
function getDatabaseToolsSqlReportsOutput(args: GetDatabaseToolsSqlReportsOutputArgs, opts?: InvokeOptions): Output<GetDatabaseToolsSqlReportsResult>
    def get_database_tools_sql_reports(compartment_id: Optional[str] = None,
                                   display_name: Optional[str] = None,
                                   filters: Optional[Sequence[GetDatabaseToolsSqlReportsFilter]] = None,
                                   state: Optional[str] = None,
                                   types: Optional[Sequence[str]] = None,
                                   opts: Optional[InvokeOptions] = None) -> GetDatabaseToolsSqlReportsResult
def get_database_tools_sql_reports_output(compartment_id: pulumi.Input[Optional[str]] = None,
                                   display_name: pulumi.Input[Optional[str]] = None,
                                   filters: pulumi.Input[Optional[Sequence[pulumi.Input[GetDatabaseToolsSqlReportsFilterArgs]]]] = None,
                                   state: pulumi.Input[Optional[str]] = None,
                                   types: pulumi.Input[Optional[Sequence[pulumi.Input[str]]]] = None,
                                   opts: Optional[InvokeOptions] = None) -> Output[GetDatabaseToolsSqlReportsResult]
    func GetDatabaseToolsSqlReports(ctx *Context, args *GetDatabaseToolsSqlReportsArgs, opts ...InvokeOption) (*GetDatabaseToolsSqlReportsResult, error)
func GetDatabaseToolsSqlReportsOutput(ctx *Context, args *GetDatabaseToolsSqlReportsOutputArgs, opts ...InvokeOption) GetDatabaseToolsSqlReportsResultOutput

    > Note: This function is named GetDatabaseToolsSqlReports in the Go SDK.

    public static class GetDatabaseToolsSqlReports 
{
    public static Task<GetDatabaseToolsSqlReportsResult> InvokeAsync(GetDatabaseToolsSqlReportsArgs args, InvokeOptions? opts = null)
    public static Output<GetDatabaseToolsSqlReportsResult> Invoke(GetDatabaseToolsSqlReportsInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetDatabaseToolsSqlReportsResult> getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs args, InvokeOptions options)
public static Output<GetDatabaseToolsSqlReportsResult> getDatabaseToolsSqlReports(GetDatabaseToolsSqlReportsArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseTools/getDatabaseToolsSqlReports:getDatabaseToolsSqlReports
  arguments:
    # arguments dictionary
    data "oci_databasetools_getdatabasetoolssqlreports" "name" {
    # arguments
}

    The following arguments are supported:

    CompartmentId string
    The OCID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Filters List<GetDatabaseToolsSqlReportsFilter>
    State string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    Types List<string>
    A filter to return only resources with one of the specified type values.
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    Filters []GetDatabaseToolsSqlReportsFilter
    State string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    Types []string
    A filter to return only resources with one of the specified type values.
    compartment_id string
    The OCID of the compartment in which to list resources.
    display_name string
    A filter to return only resources that match the entire specified display name.
    filters list(object)
    state string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    types list(string)
    A filter to return only resources with one of the specified type values.
    compartmentId String
    The OCID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire specified display name.
    filters List<GetSqlReportsFilter>
    state String
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    types List<String>
    A filter to return only resources with one of the specified type values.
    compartmentId string
    The OCID of the compartment in which to list resources.
    displayName string
    A filter to return only resources that match the entire specified display name.
    filters GetDatabaseToolsSqlReportsFilter[]
    state string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    types string[]
    A filter to return only resources with one of the specified type values.
    compartment_id str
    The OCID of the compartment in which to list resources.
    display_name str
    A filter to return only resources that match the entire specified display name.
    filters Sequence[GetDatabaseToolsSqlReportsFilter]
    state str
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    types Sequence[str]
    A filter to return only resources with one of the specified type values.
    compartmentId String
    The OCID of the compartment in which to list resources.
    displayName String
    A filter to return only resources that match the entire specified display name.
    filters List<Property Map>
    state String
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    types List<String>
    A filter to return only resources with one of the specified type values.

    getDatabaseToolsSqlReports Result

    The following output properties are available:

    CompartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    DatabaseToolsSqlReportCollections List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection>
    The list of database_tools_sql_report_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    DisplayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Filters List<GetDatabaseToolsSqlReportsFilter>
    State string
    The current state of the Database Tools SQL report.
    Types List<string>
    The type of the variable
    CompartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    DatabaseToolsSqlReportCollections []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection
    The list of database_tools_sql_report_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    DisplayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Filters []GetDatabaseToolsSqlReportsFilter
    State string
    The current state of the Database Tools SQL report.
    Types []string
    The type of the variable
    compartment_id string
    The OCID of the compartment containing the Database Tools SQL report.
    database_tools_sql_report_collections list(object)
    The list of database_tools_sql_report_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    display_name string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    filters list(object)
    state string
    The current state of the Database Tools SQL report.
    types list(string)
    The type of the variable
    compartmentId String
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportCollections List<GetSqlReportsSqlReportCollection>
    The list of database_tools_sql_report_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    displayName String
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    filters List<GetSqlReportsFilter>
    state String
    The current state of the Database Tools SQL report.
    types List<String>
    The type of the variable
    compartmentId string
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportCollections GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection[]
    The list of database_tools_sql_report_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    displayName string
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    filters GetDatabaseToolsSqlReportsFilter[]
    state string
    The current state of the Database Tools SQL report.
    types string[]
    The type of the variable
    compartment_id str
    The OCID of the compartment containing the Database Tools SQL report.
    database_tools_sql_report_collections Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection]
    The list of database_tools_sql_report_collection.
    id str
    The provider-assigned unique ID for this managed resource.
    display_name str
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    filters Sequence[GetDatabaseToolsSqlReportsFilter]
    state str
    The current state of the Database Tools SQL report.
    types Sequence[str]
    The type of the variable
    compartmentId String
    The OCID of the compartment containing the Database Tools SQL report.
    databaseToolsSqlReportCollections List<Property Map>
    The list of database_tools_sql_report_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    displayName String
    A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    filters List<Property Map>
    state String
    The current state of the Database Tools SQL report.
    types List<String>
    The type of the variable

    Supporting Types

    GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollection

    GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItem

    Columns List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DefinedTags Dictionary<string, string>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    FreeformTags Dictionary<string, string>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    The OCID of the Database Tools SQL report.
    Instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    LifecycleDetails string
    A message describing the current state in more detail.
    Locks List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock>
    Locks associated with this resource.
    Purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    Source string
    SQL query executed to generate the report.
    State string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    SystemTags Dictionary<string, string>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    Variables List<GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable>
    Variables referenced in the Database Tools SQL Report source.
    Columns []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    The OCID of the compartment in which to list resources.
    DefinedTags map[string]string
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    The description of the variable
    DisplayName string
    A filter to return only resources that match the entire specified display name.
    FreeformTags map[string]string
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Id string
    The OCID of the Database Tools SQL report.
    Instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    LifecycleDetails string
    A message describing the current state in more detail.
    Locks []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock
    Locks associated with this resource.
    Purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    Source string
    SQL query executed to generate the report.
    State string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    SystemTags map[string]string
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    TimeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    Variables []GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable
    Variables referenced in the Database Tools SQL Report source.
    columns list(object)
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id string
    The OCID of the compartment in which to list resources.
    defined_tags map(string)
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    display_name string
    A filter to return only resources that match the entire specified display name.
    freeform_tags map(string)
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id string
    The OCID of the Database Tools SQL report.
    instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycle_details string
    A message describing the current state in more detail.
    locks list(object)
    Locks associated with this resource.
    purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source string
    SQL query executed to generate the report.
    state string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    system_tags map(string)
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    time_updated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    variables list(object)
    Variables referenced in the Database Tools SQL Report source.
    columns List<GetSqlReportsSqlReportCollectionItemColumn>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    The OCID of the compartment in which to list resources.
    definedTags Map<String,String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A filter to return only resources that match the entire specified display name.
    freeformTags Map<String,String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    The OCID of the Database Tools SQL report.
    instructions String
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails String
    A message describing the current state in more detail.
    locks List<GetSqlReportsSqlReportCollectionItemLock>
    Locks associated with this resource.
    purpose String
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source String
    SQL query executed to generate the report.
    state String
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    systemTags Map<String,String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.
    variables List<GetSqlReportsSqlReportCollectionItemVariable>
    Variables referenced in the Database Tools SQL Report source.
    columns GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn[]
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId string
    The OCID of the compartment in which to list resources.
    definedTags {[key: string]: string}
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    The description of the variable
    displayName string
    A filter to return only resources that match the entire specified display name.
    freeformTags {[key: string]: string}
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id string
    The OCID of the Database Tools SQL report.
    instructions string
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails string
    A message describing the current state in more detail.
    locks GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock[]
    Locks associated with this resource.
    purpose string
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source string
    SQL query executed to generate the report.
    state string
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    systemTags {[key: string]: string}
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated string
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    variables GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable[]
    Variables referenced in the Database Tools SQL Report source.
    columns Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn]
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id str
    The OCID of the compartment in which to list resources.
    defined_tags Mapping[str, str]
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    The description of the variable
    display_name str
    A filter to return only resources that match the entire specified display name.
    freeform_tags Mapping[str, str]
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id str
    The OCID of the Database Tools SQL report.
    instructions str
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycle_details str
    A message describing the current state in more detail.
    locks Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock]
    Locks associated with this resource.
    purpose str
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source str
    SQL query executed to generate the report.
    state str
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    system_tags Mapping[str, str]
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    time_created str
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    time_updated str
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type str
    A filter to return only resources with one of the specified type values.
    variables Sequence[GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable]
    Variables referenced in the Database Tools SQL Report source.
    columns List<Property Map>
    Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    The OCID of the compartment in which to list resources.
    definedTags Map<String>
    Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    The description of the variable
    displayName String
    A filter to return only resources that match the entire specified display name.
    freeformTags Map<String>
    Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    id String
    The OCID of the Database Tools SQL report.
    instructions String
    Instructions on how to use the SQL report. Step-by-step guidance for an AI agent on how to execute or fill in parameters for the report.
    lifecycleDetails String
    A message describing the current state in more detail.
    locks List<Property Map>
    Locks associated with this resource.
    purpose String
    Purpose of the Database Tools SQL report. Scenario or conditions describing when or why this report should be used. Provides selection criteria to AI agents to improve report selection accuracy.
    source String
    SQL query executed to generate the report.
    state String
    A filter to return resources only when their databaseToolsSqlReportLifecycleState matches the specified databaseToolsSqlReportLifecycleState.
    systemTags Map<String>
    Usage of system tag keys. These predefined keys are scoped to namespaces. Example: {"orcl-cloud.free-tier-retained": "true"}
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    timeUpdated String
    The time the Database Tools SQL report was updated. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.
    variables List<Property Map>
    Variables referenced in the Database Tools SQL Report source.

    GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemColumn

    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description str
    The description of the variable
    name str
    The name of the variable
    type str
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.

    GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemLock

    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    Message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    RelatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    TimeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    Type string
    A filter to return only resources with one of the specified type values.
    message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    related_resource_id string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.
    message string
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId string
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated string
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type string
    A filter to return only resources with one of the specified type values.
    message str
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    related_resource_id str
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    time_created str
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type str
    A filter to return only resources with one of the specified type values.
    message String
    A message added by the creator of the lock. This is typically used to give an indication of why the resource is locked.
    relatedResourceId String
    The id of the resource that is locking this resource. Indicates that deleting this resource will remove the lock.
    timeCreated String
    The time the Database Tools SQL report was created. An RFC3339 formatted datetime string.
    type String
    A filter to return only resources with one of the specified type values.

    GetDatabaseToolsSqlReportsDatabaseToolsSqlReportCollectionItemVariable

    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    Description string
    The description of the variable
    Name string
    The name of the variable
    Type string
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.
    description string
    The description of the variable
    name string
    The name of the variable
    type string
    A filter to return only resources with one of the specified type values.
    description str
    The description of the variable
    name str
    The name of the variable
    type str
    A filter to return only resources with one of the specified type values.
    description String
    The description of the variable
    name String
    The name of the variable
    type String
    A filter to return only resources with one of the specified type values.

    GetDatabaseToolsSqlReportsFilter

    Name string
    The name of the variable
    Values List<string>
    Regex bool
    Name string
    The name of the variable
    Values []string
    Regex bool
    name string
    The name of the variable
    values list(string)
    regex bool
    name String
    The name of the variable
    values List<String>
    regex Boolean
    name string
    The name of the variable
    values string[]
    regex boolean
    name str
    The name of the variable
    values Sequence[str]
    regex bool
    name String
    The name of the variable
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Viewing docs for Oracle Cloud Infrastructure v4.13.0
    published on Thursday, May 28, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial