OraFAQ Forum: Data Integration » Save Query results into text file

Home » Developer & Programmer » Data Integration » Save Query results into text file (Oracle EBS, R12.0.0.6, Windows)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Save Query results into text file [message #661542]

Thu, 23 March 2017 06:47

Mraouf
Messages: 14
Registered: June 2016
Location: Egypt

Junior Member

is there any method to save query results into text file

Report message to a moderator

Re: Save Query results into text file [message #661545 is a reply to message #661542]

Thu, 23 March 2017 07:29

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Save Query results into text file [message #661546 is a reply to message #661545]

Thu, 23 March 2017 07:34

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

Report message to a moderator

Re: Save Query results into text file [message #661547 is a reply to message #661546]

Thu, 23 March 2017 07:47

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	Read File
Next Topic:	sql statement for fusion database and own database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 05:13:17 CST 2024