Home » SQL & PL/SQL » SQL & PL/SQL » Export Query Result to text file (Oracle 10g, Windows.)
Export Query Result to text file [message #276496] Thu, 25 October 2007 05:48 Go to next message
Veeram
Messages: 2
Registered: October 2007
Junior Member
Dear Friends,
Im New to Oracle and im in need of saving the Result of a Query into to Text File. Im doing this with Delphi 5. Could any of u help me out.


Thanx in Advance
Re: Export Query Result to text file [message #276504 is a reply to message #276496] Thu, 25 October 2007 06:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you know how to fetch the records from the query in Delphi?
Do you know how to write into a file in Delphi?
If yes, then you know how to do what you want.
If no, then post what you don't know.

Regards
Michel
Re: Export Query Result to text file [message #276514 is a reply to message #276504] Thu, 25 October 2007 06:55 Go to previous messageGo to next message
Veeram
Messages: 2
Registered: October 2007
Junior Member
I Know to fetch the records using Delphi.

My Problem is that the records are being written to a text file using a loop. As the no of Records are around 1,00,00,000 the process takes a long time. So i would like to have a better solution to minimize the Time Span of the Process.

Thanx for ur reply and hope u could help me ot of the issue.
Re: Export Query Result to text file [message #276518 is a reply to message #276514] Thu, 25 October 2007 07:01 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your neighbour Manoop that posted the same question from the same place:
http://www.orafaq.com/forum/m/273942/102589/?srch=delphi#msg_273942
The answer is the same.

Regards
Michel
Previous Topic: Accessing DBA% tables in a SP
Next Topic: select query
Goto Forum:
  


Current Time: Mon Dec 05 21:33:29 CST 2016

Total time taken to generate the page: 0.08636 seconds