Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Is the Quickest Way to Export a Table to a Flat File
What Is the Quickest Way to Export a Table to a Flat File? - Oracle DBA FAQ - Loading and Exporting Data
✍: FYIcenter.com
The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following tutorial exercise shows you how control the output format, start the spooler, and dump all record from a table to a flat text file:
>mkdir \oraclexe\test >sqlplus /nolog SQL> connect HR/fyicenter SQL> SET HEADING OFF; SQL> SET FEEDBACK OFF; SQL> SET LINESIZE 1000; SQL> SPOOL \oraclexe\test\employees.txt; SQL> SELECT * FROM EMPLOYEES; ...... SQL> SPOOL OFF;
You should get all records in employees.txt with fixed length fields.
2007-04-30, 4737👍, 0💬
Popular Posts:
How To Return Top 5 Rows? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want ...
How To Define a Data Source Name (DSN) in ODBC Manager? - Oracle DBA FAQ - ODBC Drivers, DSN Configu...
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
.NET INTERVIEW QUESTIONS - What is Suspend and Resume in Threading ? It is Similar to Sleep and Inte...
What is a delegate ? Delegate is a class that can hold a reference to a method or a function. Delega...