How to export table data to .csv fil and send that file to folder using sql commands?
Greetings for the day!!!
I am really hoping that i would get solution for my question. My question is i want to know the logic for exporting the data from oracle table to .csv file and .csv file should be placed in specified folder on desktop. Earlier I was manually exporting the data into .csv files and placed those files into manually created folders. But now i have to do it 200 folders . It is impossible for me to do manually. So please some one help in this , how can i do it automatically using plsql code. I am using oracle 11g.
Thanks in advance!!