There are different ways you can achieve this. One is by Using Unix Scripts if you have access to do so in your Project and other is by UTL_FILE utility. In this post, we will see how it can be done using ORACLE Stored Procedure- I will write a separate post for Unix Scripting.