SQL & PL/SQL

Hi All,

There have a query which returns two rows as output.

select 'Orange' item1,'Rice' item2,'Keyboard' item3,'Mobile' item4,'Bike' item5,'Book' item6,'Pen' item7 from dual

union all

select 'Orange' item1,'' item2,'Keyboard' item3,'Mobile' item4,'Car' item5,'Book' item6,'Pencil' item7 from dual;

The requirement is, the output should only contain data which are different.ie

Is there a direct way to achieve this in sql query.

Valuable comments are really appreciated.

Thank You