Hi Team,
I am new to PL/Sql, My requirement is that I have one table in which all the required columns available for my output. I need a script to generate 3 dat files from this table and after getting output I need to compress all three files to one file with some name.
Table consists of col1,col2,col3....col10
first dat file will have col1 to col3
second dat file will have col4 to col6
third dat file will have col7 to col10
and finally output should be stored in local c drive as sample.zip
Can any one tell me how to achieve this functionality?
Thanks in Advance,
Samthosh.