Collections:
Export Data to a CSV File in Oracle
How To Export Data to a CSV File in Oracle?
✍: FYIcenter.com
If you want to export data from a table to a file in CSV format, you can use the following steps:
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.
2019-01-26, 794👍, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How To Create a View on an Existing Table in SQL Server? If you want to a view on an existing table,...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...