distinct
Use this command to remove duplicates from the returned results.
Syntax
distinct <field_name> (,<field_name>)*Parameters
The following table lists the parameters used with this command, along with their descriptions.
| Parameter | Description |
|---|---|
|
|
Use this parameter to specify the field name. |
The following query returns the distinct list of entities having ORA-00600 errors.
Message like '%ORA-00600%' | distinct 'Entity Type', Entity