console_history_contents

Creates, updates, deletes, gets or lists a console_history_contents resource.

Overview

Name	console_history_contents
Type	Resource
Id	oci.database.console_history_contents

Fields

The following fields are returned by SELECT queries:

get

The console history content was retrieved.

Name	Datatype	Description

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	dbNodeId, consoleHistoryId, region	opc-request-id	Retrieves the specified database node console history contents upto a megabyte.<br />

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
consoleHistoryId	string	The OCID of the console history.
dbNodeId	string	The database node [OCID](/Content/General/Concepts/identifiers.htm).
region	string	OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION)
opc-request-id	string	Unique identifier for the request.

SELECT examples

get

Retrieves the specified database node console history contents upto a megabyte.<br />

SELECT
*
FROM oci.database.console_history_contents
WHERE dbNodeId = '{{ dbNodeId }}' -- required
AND consoleHistoryId = '{{ consoleHistoryId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;