Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table individual ( id, status, language )
as
select 1000, '1', 'en' from dual union all
select 1001, '1', 'en' from dual union all
select 1002, '1', 'de' from dual union all
select 2000, '2', 'es' from dual union all
select 2001, '2', 'fr' from dual ;
5 rows affected

create table msisdn ( individualid, msisdn, country )
as
select 1000, 9321767493, 'IN' from dual union all
select 1001, 4421767493, 'GB' from dual union all
select 1002, 4921767493, 'DE' from dual ;
3 rows affected

select
   m.msisdn || ',' || 'MSISDN' || ',' || i.language || '_' || m.country
   as "identifier,type,locale" 
from
    individual i join msisdn m on i.id = m.individualid 
where
       i.status = '1' 
   and rownum < 11;


identifier,type,locale


9321767493,MSISDN,en_IN

4421767493,MSISDN,en_GB

4921767493,MSISDN,de_DE