How To Export Data to a CSV File
Q
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: FYIcenter.com
A
If you want to export data from a table to a file in CSV format, you can use the following steps:
- Right-click the table name, EMPLOYEES, in the object tree view.
- Select Export.
- Select CSV. The Export Data window shows up.
- Click Format tab.
- Select Format as: CSV.
- Enter File as: \temp\MyTeam.csv.
- Click Columns tab.
- Check columns: FIRST_NAME, LAST_NAME, MANAGER_ID
- Click Where tab.
- Enter Where clause as: MANAGER_ID=100.
- Click Apply.
Your CSV file, \temp\MyTeam.csv, is ready. Open it, you will see:
"FIRST_NAME","LAST_NAME","MANAGER_ID" "Gerald","Cambrault","100" "Lex","De Haan","100" "Alberto","Errazuriz","100" "Adam","Fripp","100" "Michael","Hartstein","100" "Payam","Kaufling","100" "Neena","Kochhar","100" ...
CSV files can be open by Microsoft Excel.
2007-04-27, 7948👍, 0💬
Related Topics: