Home » Developer & Programmer » Data Integration » Save Query results into text file (Oracle EBS, R12.0.0.6, Windows)
|
|
|
Re: Save Query results into text file [message #661547 is a reply to message #661546] |
Thu, 23 March 2017 07:47  |
 |
Littlefoot
Messages: 21824 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Here are a few options.
If you use SQL*Plus, use its SPOOL command and spool the result into a txt file.
UTL_FILE is a package which is used in PL/SQL; it creates files on a database server (not locally). You'll have to create a DIRECTORY (an Oracle object which points to some directory on the server) and grant read/write privileges on it to Oracle user which is going to create a file.
If you use some GUI tool (such as TOAD or SQL Developer), you can export the result into various file formats (txt included).
|
|
|
Goto Forum:
Current Time: Thu May 15 18:49:55 CDT 2025
|