Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Export Data to a CSV File
How To Export Data to a CSV File? - Oracle DBA FAQ - Introduction to Oracle SQL Developer
✍: 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.
2007-04-27, 8180👍, 0💬
Popular Posts:
How To Use "IF" Statements on Multiple Conditions? - Oracle DBA FAQ - Understanding PL/SQL Language ...
How To Write a Query with a Right Outer Join? - Oracle DBA FAQ - Understanding SQL SELECT Query Stat...
What is normalization? What are different types of normalization? It is set of rules that have been ...
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...
How To View Existing Locks on the Database? - Oracle DBA FAQ - Understanding SQL Transaction Managem...