Home » Developer & Programmer » Data Integration » Save Query results into text file (Oracle EBS, R12.0.0.6, Windows)
Save Query results into text file [message #661542] Thu, 23 March 2017 06:47 Go to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
is there any method to save query results into text file
Re: Save Query results into text file [message #661545 is a reply to message #661542] Thu, 23 March 2017 07:29 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not sure whether you asked a "general" question (if so, I know a few ways to do that), or is it related to EBS (in that case, I have no idea).
Re: Save Query results into text file [message #661546 is a reply to message #661545] Thu, 23 March 2017 07:34 Go to previous messageGo to next message
Mraouf
Messages: 14
Registered: June 2016
Location: Egypt
Junior Member
i mean how can i retrieve the query result into a text file on the local machine or the server.. such using utl package.. if there are a method let me know how
Re: Save Query results into text file [message #661547 is a reply to message #661546] Thu, 23 March 2017 07:47 Go to previous message
Littlefoot
Messages: 21805
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).
Previous Topic: Read File
Next Topic: sql statement for fusion database and own database
Goto Forum:
  


Current Time: Mon Mar 18 22:48:11 CDT 2024