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

oci.DatabaseTools.DatabaseToolsSqlReport

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

    This resource provides the Database Tools Sql Report resource in Oracle Cloud Infrastructure Database Tools service. Api doc link for the resource: https://docs.oracle.com/iaas/api/#/en/database-tools/latest/DatabaseToolsSqlReport

    Example terraform configs related to the resource : https://github.com/oracle/terraform-provider-oci/tree/master/examples/databaseTools

    Creates a new Database Tools Sql Report.

    Example Usage

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

const testDatabaseToolsSqlReport = new oci.databasetools.DatabaseToolsSqlReport("test_database_tools_sql_report", {
    compartmentId: compartmentId,
    displayName: databaseToolsSqlReportDisplayName,
    source: databaseToolsSqlReportSource,
    type: databaseToolsSqlReportType,
    columns: [{
        description: databaseToolsSqlReportColumnsDescription,
        name: databaseToolsSqlReportColumnsName,
        type: databaseToolsSqlReportColumnsType,
    }],
    definedTags: {
        "foo-namespace.bar-key": "value",
    },
    description: databaseToolsSqlReportDescription,
    freeformTags: {
        "bar-key": "value",
    },
    instructions: databaseToolsSqlReportInstructions,
    locks: [{
        type: databaseToolsSqlReportLocksType,
        message: databaseToolsSqlReportLocksMessage,
        relatedResourceId: testResource.id,
        timeCreated: databaseToolsSqlReportLocksTimeCreated,
    }],
    purpose: databaseToolsSqlReportPurpose,
    variables: [{
        description: databaseToolsSqlReportVariablesDescription,
        name: databaseToolsSqlReportVariablesName,
        type: databaseToolsSqlReportVariablesType,
    }],
});

    import pulumi
import pulumi_oci as oci

test_database_tools_sql_report = oci.databasetools.DatabaseToolsSqlReport("test_database_tools_sql_report",
    compartment_id=compartment_id,
    display_name=database_tools_sql_report_display_name,
    source=database_tools_sql_report_source,
    type=database_tools_sql_report_type,
    columns=[{
        "description": database_tools_sql_report_columns_description,
        "name": database_tools_sql_report_columns_name,
        "type": database_tools_sql_report_columns_type,
    }],
    defined_tags={
        "foo-namespace.bar-key": "value",
    },
    description=database_tools_sql_report_description,
    freeform_tags={
        "bar-key": "value",
    },
    instructions=database_tools_sql_report_instructions,
    locks=[{
        "type": database_tools_sql_report_locks_type,
        "message": database_tools_sql_report_locks_message,
        "related_resource_id": test_resource["id"],
        "time_created": database_tools_sql_report_locks_time_created,
    }],
    purpose=database_tools_sql_report_purpose,
    variables=[{
        "description": database_tools_sql_report_variables_description,
        "name": database_tools_sql_report_variables_name,
        "type": database_tools_sql_report_variables_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.NewDatabaseToolsSqlReport(ctx, "test_database_tools_sql_report", &databasetools.DatabaseToolsSqlReportArgs{
			CompartmentId: pulumi.Any(compartmentId),
			DisplayName:   pulumi.Any(databaseToolsSqlReportDisplayName),
			Source:        pulumi.Any(databaseToolsSqlReportSource),
			Type:          pulumi.Any(databaseToolsSqlReportType),
			Columns: databasetools.DatabaseToolsSqlReportColumnArray{
				&databasetools.DatabaseToolsSqlReportColumnArgs{
					Description: pulumi.Any(databaseToolsSqlReportColumnsDescription),
					Name:        pulumi.Any(databaseToolsSqlReportColumnsName),
					Type:        pulumi.Any(databaseToolsSqlReportColumnsType),
				},
			},
			DefinedTags: pulumi.StringMap{
				"foo-namespace.bar-key": pulumi.String("value"),
			},
			Description: pulumi.Any(databaseToolsSqlReportDescription),
			FreeformTags: pulumi.StringMap{
				"bar-key": pulumi.String("value"),
			},
			Instructions: pulumi.Any(databaseToolsSqlReportInstructions),
			Locks: databasetools.DatabaseToolsSqlReportLockArray{
				&databasetools.DatabaseToolsSqlReportLockArgs{
					Type:              pulumi.Any(databaseToolsSqlReportLocksType),
					Message:           pulumi.Any(databaseToolsSqlReportLocksMessage),
					RelatedResourceId: pulumi.Any(testResource.Id),
					TimeCreated:       pulumi.Any(databaseToolsSqlReportLocksTimeCreated),
				},
			},
			Purpose: pulumi.Any(databaseToolsSqlReportPurpose),
			Variables: databasetools.DatabaseToolsSqlReportVariableArray{
				&databasetools.DatabaseToolsSqlReportVariableArgs{
					Description: pulumi.Any(databaseToolsSqlReportVariablesDescription),
					Name:        pulumi.Any(databaseToolsSqlReportVariablesName),
					Type:        pulumi.Any(databaseToolsSqlReportVariablesType),
				},
			},
		})
		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 testDatabaseToolsSqlReport = new Oci.DatabaseTools.DatabaseToolsSqlReport("test_database_tools_sql_report", new()
    {
        CompartmentId = compartmentId,
        DisplayName = databaseToolsSqlReportDisplayName,
        Source = databaseToolsSqlReportSource,
        Type = databaseToolsSqlReportType,
        Columns = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportColumnArgs
            {
                Description = databaseToolsSqlReportColumnsDescription,
                Name = databaseToolsSqlReportColumnsName,
                Type = databaseToolsSqlReportColumnsType,
            },
        },
        DefinedTags = 
        {
            { "foo-namespace.bar-key", "value" },
        },
        Description = databaseToolsSqlReportDescription,
        FreeformTags = 
        {
            { "bar-key", "value" },
        },
        Instructions = databaseToolsSqlReportInstructions,
        Locks = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportLockArgs
            {
                Type = databaseToolsSqlReportLocksType,
                Message = databaseToolsSqlReportLocksMessage,
                RelatedResourceId = testResource.Id,
                TimeCreated = databaseToolsSqlReportLocksTimeCreated,
            },
        },
        Purpose = databaseToolsSqlReportPurpose,
        Variables = new[]
        {
            new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportVariableArgs
            {
                Description = databaseToolsSqlReportVariablesDescription,
                Name = databaseToolsSqlReportVariablesName,
                Type = databaseToolsSqlReportVariablesType,
            },
        },
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseTools.DatabaseToolsSqlReport;
import com.pulumi.oci.DatabaseTools.DatabaseToolsSqlReportArgs;
import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsSqlReportColumnArgs;
import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsSqlReportLockArgs;
import com.pulumi.oci.DatabaseTools.inputs.DatabaseToolsSqlReportVariableArgs;
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) {
        var testDatabaseToolsSqlReport = new DatabaseToolsSqlReport("testDatabaseToolsSqlReport", DatabaseToolsSqlReportArgs.builder()
            .compartmentId(compartmentId)
            .displayName(databaseToolsSqlReportDisplayName)
            .source(databaseToolsSqlReportSource)
            .type(databaseToolsSqlReportType)
            .columns(DatabaseToolsSqlReportColumnArgs.builder()
                .description(databaseToolsSqlReportColumnsDescription)
                .name(databaseToolsSqlReportColumnsName)
                .type(databaseToolsSqlReportColumnsType)
                .build())
            .definedTags(Map.of("foo-namespace.bar-key", "value"))
            .description(databaseToolsSqlReportDescription)
            .freeformTags(Map.of("bar-key", "value"))
            .instructions(databaseToolsSqlReportInstructions)
            .locks(DatabaseToolsSqlReportLockArgs.builder()
                .type(databaseToolsSqlReportLocksType)
                .message(databaseToolsSqlReportLocksMessage)
                .relatedResourceId(testResource.id())
                .timeCreated(databaseToolsSqlReportLocksTimeCreated)
                .build())
            .purpose(databaseToolsSqlReportPurpose)
            .variables(DatabaseToolsSqlReportVariableArgs.builder()
                .description(databaseToolsSqlReportVariablesDescription)
                .name(databaseToolsSqlReportVariablesName)
                .type(databaseToolsSqlReportVariablesType)
                .build())
            .build());

    }
}

    resources:
  testDatabaseToolsSqlReport:
    type: oci:DatabaseTools:DatabaseToolsSqlReport
    name: test_database_tools_sql_report
    properties:
      compartmentId: ${compartmentId}
      displayName: ${databaseToolsSqlReportDisplayName}
      source: ${databaseToolsSqlReportSource}
      type: ${databaseToolsSqlReportType}
      columns:
        - description: ${databaseToolsSqlReportColumnsDescription}
          name: ${databaseToolsSqlReportColumnsName}
          type: ${databaseToolsSqlReportColumnsType}
      definedTags:
        foo-namespace.bar-key: value
      description: ${databaseToolsSqlReportDescription}
      freeformTags:
        bar-key: value
      instructions: ${databaseToolsSqlReportInstructions}
      locks:
        - type: ${databaseToolsSqlReportLocksType}
          message: ${databaseToolsSqlReportLocksMessage}
          relatedResourceId: ${testResource.id}
          timeCreated: ${databaseToolsSqlReportLocksTimeCreated}
      purpose: ${databaseToolsSqlReportPurpose}
      variables:
        - description: ${databaseToolsSqlReportVariablesDescription}
          name: ${databaseToolsSqlReportVariablesName}
          type: ${databaseToolsSqlReportVariablesType}

    Example coming soon!

    Create DatabaseToolsSqlReport Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new DatabaseToolsSqlReport(name: string, args: DatabaseToolsSqlReportArgs, opts?: CustomResourceOptions);
    @overload
def DatabaseToolsSqlReport(resource_name: str,
                           args: DatabaseToolsSqlReportArgs,
                           opts: Optional[ResourceOptions] = None)

@overload
def DatabaseToolsSqlReport(resource_name: str,
                           opts: Optional[ResourceOptions] = None,
                           compartment_id: Optional[str] = None,
                           display_name: Optional[str] = None,
                           source: Optional[str] = None,
                           type: Optional[str] = None,
                           columns: Optional[Sequence[DatabaseToolsSqlReportColumnArgs]] = None,
                           defined_tags: Optional[Mapping[str, str]] = None,
                           description: Optional[str] = None,
                           freeform_tags: Optional[Mapping[str, str]] = None,
                           instructions: Optional[str] = None,
                           locks: Optional[Sequence[DatabaseToolsSqlReportLockArgs]] = None,
                           purpose: Optional[str] = None,
                           variables: Optional[Sequence[DatabaseToolsSqlReportVariableArgs]] = None)
    func NewDatabaseToolsSqlReport(ctx *Context, name string, args DatabaseToolsSqlReportArgs, opts ...ResourceOption) (*DatabaseToolsSqlReport, error)
    public DatabaseToolsSqlReport(string name, DatabaseToolsSqlReportArgs args, CustomResourceOptions? opts = null)
    public DatabaseToolsSqlReport(String name, DatabaseToolsSqlReportArgs args)
public DatabaseToolsSqlReport(String name, DatabaseToolsSqlReportArgs args, CustomResourceOptions options)

    type: oci:DatabaseTools:DatabaseToolsSqlReport
properties: # The arguments to resource properties.
options: # Bag of options to control resource's behavior.


    resource "oci_databasetools_databasetoolssqlreport" "name" {
    # resource properties
}

    Parameters

    name string
    The unique name of the resource.
    args DatabaseToolsSqlReportArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args DatabaseToolsSqlReportArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args DatabaseToolsSqlReportArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args DatabaseToolsSqlReportArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args DatabaseToolsSqlReportArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var databaseToolsSqlReportResource = new Oci.DatabaseTools.DatabaseToolsSqlReport("databaseToolsSqlReportResource", new()
{
    CompartmentId = "string",
    DisplayName = "string",
    Source = "string",
    Type = "string",
    Columns = new[]
    {
        new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportColumnArgs
        {
            Description = "string",
            Name = "string",
            Type = "string",
        },
    },
    DefinedTags = 
    {
        { "string", "string" },
    },
    Description = "string",
    FreeformTags = 
    {
        { "string", "string" },
    },
    Instructions = "string",
    Locks = new[]
    {
        new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportLockArgs
        {
            Type = "string",
            Message = "string",
            RelatedResourceId = "string",
            TimeCreated = "string",
        },
    },
    Purpose = "string",
    Variables = new[]
    {
        new Oci.DatabaseTools.Inputs.DatabaseToolsSqlReportVariableArgs
        {
            Description = "string",
            Name = "string",
            Type = "string",
        },
    },
});

    example, err := databasetools.NewDatabaseToolsSqlReport(ctx, "databaseToolsSqlReportResource", &databasetools.DatabaseToolsSqlReportArgs{
	CompartmentId: pulumi.String("string"),
	DisplayName:   pulumi.String("string"),
	Source:        pulumi.String("string"),
	Type:          pulumi.String("string"),
	Columns: databasetools.DatabaseToolsSqlReportColumnArray{
		&databasetools.DatabaseToolsSqlReportColumnArgs{
			Description: pulumi.String("string"),
			Name:        pulumi.String("string"),
			Type:        pulumi.String("string"),
		},
	},
	DefinedTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	Description: pulumi.String("string"),
	FreeformTags: pulumi.StringMap{
		"string": pulumi.String("string"),
	},
	Instructions: pulumi.String("string"),
	Locks: databasetools.DatabaseToolsSqlReportLockArray{
		&databasetools.DatabaseToolsSqlReportLockArgs{
			Type:              pulumi.String("string"),
			Message:           pulumi.String("string"),
			RelatedResourceId: pulumi.String("string"),
			TimeCreated:       pulumi.String("string"),
		},
	},
	Purpose: pulumi.String("string"),
	Variables: databasetools.DatabaseToolsSqlReportVariableArray{
		&databasetools.DatabaseToolsSqlReportVariableArgs{
			Description: pulumi.String("string"),
			Name:        pulumi.String("string"),
			Type:        pulumi.String("string"),
		},
	},
})

    resource "oci_databasetools_databasetoolssqlreport" "databaseToolsSqlReportResource" {
  compartment_id = "string"
  display_name   = "string"
  source         = "string"
  type           = "string"
  columns {
    description = "string"
    name        = "string"
    type        = "string"
  }
  defined_tags = {
    "string" = "string"
  }
  description = "string"
  freeform_tags = {
    "string" = "string"
  }
  instructions = "string"
  locks {
    type                = "string"
    message             = "string"
    related_resource_id = "string"
    time_created        = "string"
  }
  purpose = "string"
  variables {
    description = "string"
    name        = "string"
    type        = "string"
  }
}

    var databaseToolsSqlReportResource = new DatabaseToolsSqlReport("databaseToolsSqlReportResource", DatabaseToolsSqlReportArgs.builder()
    .compartmentId("string")
    .displayName("string")
    .source("string")
    .type("string")
    .columns(DatabaseToolsSqlReportColumnArgs.builder()
        .description("string")
        .name("string")
        .type("string")
        .build())
    .definedTags(Map.of("string", "string"))
    .description("string")
    .freeformTags(Map.of("string", "string"))
    .instructions("string")
    .locks(DatabaseToolsSqlReportLockArgs.builder()
        .type("string")
        .message("string")
        .relatedResourceId("string")
        .timeCreated("string")
        .build())
    .purpose("string")
    .variables(DatabaseToolsSqlReportVariableArgs.builder()
        .description("string")
        .name("string")
        .type("string")
        .build())
    .build());

    database_tools_sql_report_resource = oci.databasetools.DatabaseToolsSqlReport("databaseToolsSqlReportResource",
    compartment_id="string",
    display_name="string",
    source="string",
    type="string",
    columns=[{
        "description": "string",
        "name": "string",
        "type": "string",
    }],
    defined_tags={
        "string": "string",
    },
    description="string",
    freeform_tags={
        "string": "string",
    },
    instructions="string",
    locks=[{
        "type": "string",
        "message": "string",
        "related_resource_id": "string",
        "time_created": "string",
    }],
    purpose="string",
    variables=[{
        "description": "string",
        "name": "string",
        "type": "string",
    }])

    const databaseToolsSqlReportResource = new oci.databasetools.DatabaseToolsSqlReport("databaseToolsSqlReportResource", {
    compartmentId: "string",
    displayName: "string",
    source: "string",
    type: "string",
    columns: [{
        description: "string",
        name: "string",
        type: "string",
    }],
    definedTags: {
        string: "string",
    },
    description: "string",
    freeformTags: {
        string: "string",
    },
    instructions: "string",
    locks: [{
        type: "string",
        message: "string",
        relatedResourceId: "string",
        timeCreated: "string",
    }],
    purpose: "string",
    variables: [{
        description: "string",
        name: "string",
        type: "string",
    }],
});

    type: oci:DatabaseTools:DatabaseToolsSqlReport
properties:
    columns:
        - description: string
          name: string
          type: string
    compartmentId: string
    definedTags:
        string: string
    description: string
    displayName: string
    freeformTags:
        string: string
    instructions: string
    locks:
        - message: string
          relatedResourceId: string
          timeCreated: string
          type: string
    purpose: string
    source: string
    type: string
    variables:
        - description: string
          name: string
          type: string

    DatabaseToolsSqlReport Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The DatabaseToolsSqlReport resource accepts the following input properties:

    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Source string
    (Updatable) SQL query executed to generate the report.
    Type string
    (Updatable) The Database Tools SQL report type.
    Columns List<DatabaseToolsSqlReportColumn>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A description of the SQL report.
    FreeformTags Dictionary<string, string>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Instructions string
    (Updatable) 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.
    Locks List<DatabaseToolsSqlReportLock>
    Locks associated with this resource.
    Purpose string
    (Updatable) 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.
    Variables List<DatabaseToolsSqlReportVariable>
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    Source string
    (Updatable) SQL query executed to generate the report.
    Type string
    (Updatable) The Database Tools SQL report type.
    Columns []DatabaseToolsSqlReportColumnArgs
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A description of the SQL report.
    FreeformTags map[string]string
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Instructions string
    (Updatable) 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.
    Locks []DatabaseToolsSqlReportLockArgs
    Locks associated with this resource.
    Purpose string
    (Updatable) 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.
    Variables []DatabaseToolsSqlReportVariableArgs
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    compartment_id string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    display_name string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    source string
    (Updatable) SQL query executed to generate the report.
    type string
    (Updatable) The Database Tools SQL report type.
    columns list(object)
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    defined_tags map(string)
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A description of the SQL report.
    freeform_tags map(string)
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions string
    (Updatable) 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.
    locks list(object)
    Locks associated with this resource.
    purpose string
    (Updatable) 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.
    variables list(object)
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    source String
    (Updatable) SQL query executed to generate the report.
    type String
    (Updatable) The Database Tools SQL report type.
    columns List<SqlReportColumn>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A description of the SQL report.
    freeformTags Map<String,String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions String
    (Updatable) 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.
    locks List<SqlReportLock>
    Locks associated with this resource.
    purpose String
    (Updatable) 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.
    variables List<SqlReportVariable>
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    compartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    displayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    source string
    (Updatable) SQL query executed to generate the report.
    type string
    (Updatable) The Database Tools SQL report type.
    columns DatabaseToolsSqlReportColumn[]
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A description of the SQL report.
    freeformTags {[key: string]: string}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions string
    (Updatable) 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.
    locks DatabaseToolsSqlReportLock[]
    Locks associated with this resource.
    purpose string
    (Updatable) 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.
    variables DatabaseToolsSqlReportVariable[]
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    compartment_id str
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    display_name str
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    source str
    (Updatable) SQL query executed to generate the report.
    type str
    (Updatable) The Database Tools SQL report type.
    columns Sequence[DatabaseToolsSqlReportColumnArgs]
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    (Updatable) A description of the SQL report.
    freeform_tags Mapping[str, str]
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions str
    (Updatable) 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.
    locks Sequence[DatabaseToolsSqlReportLockArgs]
    Locks associated with this resource.
    purpose str
    (Updatable) 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.
    variables Sequence[DatabaseToolsSqlReportVariableArgs]
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    source String
    (Updatable) SQL query executed to generate the report.
    type String
    (Updatable) The Database Tools SQL report type.
    columns List<Property Map>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A description of the SQL report.
    freeformTags Map<String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions String
    (Updatable) 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.
    locks List<Property Map>
    Locks associated with this resource.
    purpose String
    (Updatable) 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.
    variables List<Property Map>
    (Updatable) Variables referenced in the Database Tools SQL Report source.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the DatabaseToolsSqlReport resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    A message describing the current state in more detail.
    State string
    The current state of the Database Tools SQL report.
    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.
    Id string
    The provider-assigned unique ID for this managed resource.
    LifecycleDetails string
    A message describing the current state in more detail.
    State string
    The current state of the Database Tools SQL report.
    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.
    id string
    The provider-assigned unique ID for this managed resource.
    lifecycle_details string
    A message describing the current state in more detail.
    state string
    The current state of the Database Tools SQL report.
    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.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    A message describing the current state in more detail.
    state String
    The current state of the Database Tools SQL report.
    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.
    id string
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails string
    A message describing the current state in more detail.
    state string
    The current state of the Database Tools SQL report.
    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.
    id str
    The provider-assigned unique ID for this managed resource.
    lifecycle_details str
    A message describing the current state in more detail.
    state str
    The current state of the Database Tools SQL report.
    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.
    id String
    The provider-assigned unique ID for this managed resource.
    lifecycleDetails String
    A message describing the current state in more detail.
    state String
    The current state of the Database Tools SQL report.
    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.

    Look up Existing DatabaseToolsSqlReport Resource

    Get an existing DatabaseToolsSqlReport resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: DatabaseToolsSqlReportState, opts?: CustomResourceOptions): DatabaseToolsSqlReport
    @staticmethod
def get(resource_name: str,
        id: str,
        opts: Optional[ResourceOptions] = None,
        columns: Optional[Sequence[DatabaseToolsSqlReportColumnArgs]] = None,
        compartment_id: Optional[str] = None,
        defined_tags: Optional[Mapping[str, str]] = None,
        description: Optional[str] = None,
        display_name: Optional[str] = None,
        freeform_tags: Optional[Mapping[str, str]] = None,
        instructions: Optional[str] = None,
        lifecycle_details: Optional[str] = None,
        locks: Optional[Sequence[DatabaseToolsSqlReportLockArgs]] = None,
        purpose: Optional[str] = None,
        source: Optional[str] = None,
        state: Optional[str] = None,
        system_tags: Optional[Mapping[str, str]] = None,
        time_created: Optional[str] = None,
        time_updated: Optional[str] = None,
        type: Optional[str] = None,
        variables: Optional[Sequence[DatabaseToolsSqlReportVariableArgs]] = None) -> DatabaseToolsSqlReport
    func GetDatabaseToolsSqlReport(ctx *Context, name string, id IDInput, state *DatabaseToolsSqlReportState, opts ...ResourceOption) (*DatabaseToolsSqlReport, error)
    public static DatabaseToolsSqlReport Get(string name, Input<string> id, DatabaseToolsSqlReportState? state, CustomResourceOptions? opts = null)
    public static DatabaseToolsSqlReport get(String name, Output<String> id, DatabaseToolsSqlReportState state, CustomResourceOptions options)
    resources:  _:    type: oci:DatabaseTools:DatabaseToolsSqlReport    get:      id: ${id}
    import {
  to = oci_databasetools_databasetoolssqlreport.example
  id = "${id}"
}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Columns List<DatabaseToolsSqlReportColumn>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    DefinedTags Dictionary<string, string>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A description of the SQL report.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags Dictionary<string, string>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Instructions string
    (Updatable) 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<DatabaseToolsSqlReportLock>
    Locks associated with this resource.
    Purpose string
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    State string
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    Variables List<DatabaseToolsSqlReportVariable>
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    Columns []DatabaseToolsSqlReportColumnArgs
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    CompartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    DefinedTags map[string]string
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    Description string
    (Updatable) A description of the SQL report.
    DisplayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    FreeformTags map[string]string
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    Instructions string
    (Updatable) 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 []DatabaseToolsSqlReportLockArgs
    Locks associated with this resource.
    Purpose string
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    State string
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    Variables []DatabaseToolsSqlReportVariableArgs
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    columns list(object)
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    defined_tags map(string)
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A description of the SQL report.
    display_name string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags map(string)
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions string
    (Updatable) 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
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    state string
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    variables list(object)
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    columns List<SqlReportColumn>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    definedTags Map<String,String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A description of the SQL report.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String,String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions String
    (Updatable) 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<SqlReportLock>
    Locks associated with this resource.
    purpose String
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    state String
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    variables List<SqlReportVariable>
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    columns DatabaseToolsSqlReportColumn[]
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId string
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    definedTags {[key: string]: string}
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description string
    (Updatable) A description of the SQL report.
    displayName string
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags {[key: string]: string}
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions string
    (Updatable) 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 DatabaseToolsSqlReportLock[]
    Locks associated with this resource.
    purpose string
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    state string
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    variables DatabaseToolsSqlReportVariable[]
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    columns Sequence[DatabaseToolsSqlReportColumnArgs]
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartment_id str
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    defined_tags Mapping[str, str]
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description str
    (Updatable) A description of the SQL report.
    display_name str
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeform_tags Mapping[str, str]
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions str
    (Updatable) 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[DatabaseToolsSqlReportLockArgs]
    Locks associated with this resource.
    purpose str
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    state str
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    variables Sequence[DatabaseToolsSqlReportVariableArgs]
    (Updatable) Variables referenced in the Database Tools SQL Report source.
    columns List<Property Map>
    (Updatable) Descriptive information on columns referenced in the Database Tools SQL Report source.
    compartmentId String
    (Updatable) The OCID of the compartment containing the Database Tools SQL report.
    definedTags Map<String>
    (Updatable) Defined tags for this resource. Each key is predefined and scoped to a namespace. Example: {"foo-namespace.bar-key": "value"}
    description String
    (Updatable) A description of the SQL report.
    displayName String
    (Updatable) A user-friendly name. Does not have to be unique and can be updated. Avoid entering confidential information.
    freeformTags Map<String>
    (Updatable) Simple key-value pair that is applied without any predefined name, type or scope. Exists for cross-compatibility only. Example: {"bar-key": "value"}
    instructions String
    (Updatable) 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
    (Updatable) 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
    (Updatable) SQL query executed to generate the report.
    state String
    The current state of the Database Tools SQL report.
    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
    (Updatable) The Database Tools SQL report type.
    variables List<Property Map>
    (Updatable) Variables referenced in the Database Tools SQL Report source.

    Supporting Types

    DatabaseToolsSqlReportColumn, DatabaseToolsSqlReportColumnArgs

    Description string
    (Updatable) The description of the column
    Name string
    (Updatable) The name of the column
    Type string
    (Updatable) The type of the column
    Description string
    (Updatable) The description of the column
    Name string
    (Updatable) The name of the column
    Type string
    (Updatable) The type of the column
    description string
    (Updatable) The description of the column
    name string
    (Updatable) The name of the column
    type string
    (Updatable) The type of the column
    description String
    (Updatable) The description of the column
    name String
    (Updatable) The name of the column
    type String
    (Updatable) The type of the column
    description string
    (Updatable) The description of the column
    name string
    (Updatable) The name of the column
    type string
    (Updatable) The type of the column
    description str
    (Updatable) The description of the column
    name str
    (Updatable) The name of the column
    type str
    (Updatable) The type of the column
    description String
    (Updatable) The description of the column
    name String
    (Updatable) The name of the column
    type String
    (Updatable) The type of the column

    DatabaseToolsSqlReportLock, DatabaseToolsSqlReportLockArgs

    Type string
    Type of the lock.
    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
    When the lock was created.
    Type string
    Type of the lock.
    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
    When the lock was created.
    type string
    Type of the lock.
    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
    When the lock was created.
    type String
    Type of the lock.
    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
    When the lock was created.
    type string
    Type of the lock.
    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
    When the lock was created.
    type str
    Type of the lock.
    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
    When the lock was created.
    type String
    Type of the lock.
    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
    When the lock was created.

    DatabaseToolsSqlReportVariable, DatabaseToolsSqlReportVariableArgs

    Description string
    (Updatable) The description of the variable
    Name string
    (Updatable) The name of the variable
    Type string

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Description string
    (Updatable) The description of the variable
    Name string
    (Updatable) The name of the variable
    Type string

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    description string
    (Updatable) The description of the variable
    name string
    (Updatable) The name of the variable
    type string

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    description String
    (Updatable) The description of the variable
    name String
    (Updatable) The name of the variable
    type String

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    description string
    (Updatable) The description of the variable
    name string
    (Updatable) The name of the variable
    type string

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    description str
    (Updatable) The description of the variable
    name str
    (Updatable) The name of the variable
    type str

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    description String
    (Updatable) The description of the variable
    name String
    (Updatable) The name of the variable
    type String

    (Updatable) The type of the variable

    ** IMPORTANT ** Any change to a property that does not support update will force the destruction and recreation of the resource with the new property values

    Import

    DatabaseToolsSqlReports can be imported using the id, e.g.

    $ pulumi import oci:DatabaseTools/databaseToolsSqlReport:DatabaseToolsSqlReport test_database_tools_sql_report "id"

    To learn more about importing existing cloud resources, see Importing resources.

    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.12.0
    published on Thursday, May 21, 2026 by Pulumi
    Schema (JSON)
    pulumi/pulumi-oci

      Try Pulumi Cloud free.
      Your team will thank you.

      Start free trial