SQL & PL/SQL

Hello all,

I have oracle 10g r2 on windows.

i m using utl_file procedure for writing data from oracle to csv.

i m using 2 tables for writing data from oracle to csv.

for that i have created multiple(14) procedure and each procedure generates 1 csv file total 14 csv file is genereting in one directory.

one table holds 8 csv file and other holds 6 files.

now i have a task that it should be only two (2) csv files based on table name.
ie.
if suppose my table name is A and B then A table having 8 csv file and B table having 6 csv file but in diffrent sheet.
for one csv file there will be one sheet. for table A there will be 8 sheet.
now i want to convert that 8 csv file into one(1) csv file and other six(6) csv file into one(1) csv file but in different sheet.
for one csv file will be one sheet. for table B there will be 6 sheet.
every thing is ok till i have output of 14 file.


i just wanted to confirm that , can i write a pl sql code that will create the output what i needed. or i will have to use macros for that.


thnksss....