search

`search`

Use this command to search for a logical expression.

Syntax

search <logical_expression>

Where <logical_expression> includes the following:

Parameters

The following table lists the parameters used with this query, along with their descriptions.

Parameter	Description
`logical_expression`	This parameter includes all keywords or fieldname-value pairs used to filter data.
`keyword_expression`	Use this parameter to specify the keywords or phrases you want to match. The value for this result must follow the format `<string>`, `‘<string>’`, or `“<string>”`.
`comparison_expression`	Use this parameter to compare a field to an expression. The value for this parameter must follow the format `<field_name><cmp> <eval_expression>`, `<field_name> <between_exp>`, or `<field_name> <in_exp>`.
`cmp`	Use this parameter to specify a comparative operator. Permitted values for this parameter include `=`,`!=`, `<`, `>`, `>=`, `<=`, and `[NOT] LIKE`.
`eval_expression`	Use this parameter to specify literals which represent the value of your destination field.
`value`	Use this parameter to specify a numeric or a string literal. The permitted value for this parameter must follow the format `<string_literal>` or `<numeric literal>`.
`string_literal`	Use this parameter to specify a string literal. The permitted value for this parameter must follow the format `“<string>”`, `‘<string>’`, or `<string>`.
`between_exp`	Use this parameter to specify a range. The permitted value for this parameter must follow the format `[NOT] BETWEEN (<value> \| <numeric_literal>) AND (<value> \| <numeric_literal>)`.
`in_exp`	Permitted values for this parameter must follow the format `[NOT] IN “(“<value>) (“,” (<value>)*”)”`.

For examples of using this command in typical scenarios, see:

The following query returns ORA-00600 log entries.

Message like '%ORA-00600%'

The following query returns all ORA-00600 logs and fatal logs.

Message like 'ORA-600%' or Severity = fatal

The following query returns all database logs.

'Target Type' in ('Database Instance', 'Cluster Database')

The following query returns all logs for the database MyDb.

Target = MyDb and 'Target Type' = 'Database Instance'