Question: how did you export the data from database to excel file in oracle?
Answer: Right-click the table name in the object tree view. Select Export. Select CSV. The Export Data window shows up. Click Format tab. Select Format as: CSV. Enter a file name and location. Click Columns tab. Check the columns you wish to export.