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

field_name

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