Collections:
Quickest Way to Export Data to a Flat File in Oracle
What Is the Quickest Way to Export a Table to a Flat File in Oracle?
✍: 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.
⇒ Export Data with Field Delimiters in Oracle
⇐ Simplest Tool to Run Commands on Oracle Server in Oracle
2018-06-27, 1729🔥, 0💬
Popular Posts:
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...