>Dear Sir,
>
>Is there any other alternative to ARRAY to fulfil prupose.
>I want to sql without array.
>
>please help again

If order is not important:

select name as myName from myTable ;
 union all ;
select country as myName from myTable

Cetin