# This is an automatically generated code sample.
# To make this code sample work in your Oracle Cloud tenancy,
# please replace the values for any parameters whose current values do not fit
# your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
# boolean, number, and enum parameters with values not fitting your use case).

require 'oci'

# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config

# Initialize service client with default config file
data_safe_client = OCI::DataSafe::DataSafeClient.new(config: config)

# Send the request to service, some parameters are not required, see API doc for more info
create_sql_collection_response =
  data_safe_client.create_sql_collection(
    OCI::DataSafe::Models::CreateSqlCollectionDetails.new(
      compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
      target_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-targetId-Value',
      db_user_name: 'EXAMPLE-dbUserName-Value',
      display_name: 'EXAMPLE-displayName-Value',
      description: 'EXAMPLE-description-Value',
      status: 'DISABLED',
      sql_level: 'USER_ISSUED_SQL',
      freeform_tags: {
        'EXAMPLE_KEY_EoFzD' => 'EXAMPLE_VALUE_7OsQRTlfX2X3bYaaF0ps'
      },
      defined_tags: {
        'EXAMPLE_KEY_1ATK3' => { 'EXAMPLE_KEY_xzlTL' => 'EXAMPLE--Value' }
      }
    )
  )

# Get the data from response
puts "#{create_sql_collection_response.data}"