How To Export Data to a CSV File?
• 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. How To Export Data to an XML File? If you want to export data from a table to a file in XML format, you can use the following steps: • Right-click the table name, EMPLOYEES, in the object tree view. • Select Export. • Select XML. The Export Data window shows up. • Click Format tab. • Select Format as: XML. • Enter File
