>Hi,
> I have tried to use your idea, but it doesn't return result in distinct format. Any suggestion?
>
>Thank you

Well, then revert to your original solution or just select * distinct from the first cursor, i.e.

select * from first_table ;
union select * from second_table;
into curs temp

select * distinct from temp into curs distinct_cursor