Question: how to extract data from oracle database into flat file?
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.