Question: how to export table data into flat file in oracle?
Answer: Create a Directory Object in which you will write CSV file. Create Stored Procedure with UTL_FILE Package. Now run the Procedure and check if Data has been Exported.