Question: how to export data from sql developer to text file?
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.