search
Use this command to search for a logical expression.
Syntax
search <logical_expression>Where <logical_expression> includes the following:
-
<keyword_expression> -
<comparison_expression> -
<cmp> -
<eval_expression> -
<value> -
<string_literal> -
<between_exp> -
<in_exp>
Parameters
The following table lists the parameters used with this query, along with their descriptions.
| Parameter | Description |
|---|---|
|
|
This parameter includes all keywords or fieldname-value pairs used to filter data. |
|
|
Use this parameter to specify the keywords or phrases you want to match. The value for this result must follow the format |
|
|
Use this parameter to compare a field to an expression. The value for this parameter must follow the format |
|
|
Use this parameter to specify a comparative operator. Permitted values for this parameter include |
|
|
Use this parameter to specify literals which represent the value of your destination field. |
|
|
Use this parameter to specify a numeric or a string literal. The permitted value for this parameter must follow the format |
|
|
Use this parameter to specify a string literal. The permitted value for this parameter must follow the format |
|
|
Use this parameter to specify a range. The permitted value for this parameter must follow the format |
|
|
Permitted values for this parameter must follow the format |
Functions Available with the Command
You can use the following functions with the search command:
| Function | Description | Example |
|---|---|---|
|
|
Searches for the md5 encoded value |
* | search md5("hash my input") |
|
|
Searches for the sha1 encoded value |
* | search sha1("hash my input") |
|
|
Searches for the sha256 encoded value |
* | search sha256("hash my input") |
|
|
Searches for the sha512 encoded value |
* | search sha512("hash my input") |
|
|
Searches for the Base64 encoded value |
* | search encode64("my input") |
|
|
Searches for the Base64 decoded value |
* | search decode64("encoded input") |
|
|
Note: This is equivalent of (condition1 OR condition2 OR ... conditionN) Note: This can also be used in eval/where |
|
|
|
Note: This is equivalent of (condition1 AND condition2 AND ... conditionN) Note: This can also be used in eval/where |
|
|
|
Note: This is equivalent of (field1 = value OR field2 = value OR ...) Note: This can also be used in eval/where |
* | search anyFields('Project*') != nullTranslates to: search for ('Project ID' != null or 'Project Name' != null or 'Project Description' != null) |
|
|
Note: This is equivalent of (field1 = value AND field2 = value OR ...) Note: This can also be used in eval/where |
* | search allFields('Project*') != null
Translates to: search for ('Project ID' != null and 'Project Name' != null and 'Project Description' != null) |
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'