Hello All,
I am using Oracle 11g and trying to output my table data in multiple flat files base on country iso code records. As the data is huge I cannot use spool command. Could some one please help me out with UTL command.
Table as below with sample data
Create table list_country
(
iso_code char(3),
country_name varchar2(20),
Region_id varchar2(10),
Region_Name varchar(20)
);
insert into list_country VALUES ('BEL', 'Belgium', 'R1', 'Flemish');
insert into list_country VALUES ('BEL', 'Belgium', 'R2', 'Flanders');
insert into list_country VALUES ('BEL', 'Belgium', 'R3', 'Walloon');
insert into list_country VALUES ('BEL', 'Belgium', 'R4', 'Brussels');
insert into list_country VALUES ('EST', 'Estonia', 'R1', 'Tallinn');
insert into list_country VALUES ('EST', 'Estonia', 'R2', 'Narva');
insert into list_country VALUES ('GIN', 'Guinea', 'R1', 'Kindia');
insert into list_country VALUES ('GIN', 'Guinea', 'R2', 'Conakry');
insert into list_country VALUES ('GIN', 'Guinea', 'R3', 'Camayenne');
Thanks in Advance and Regards
Saaz