Home » RDBMS Server » Server Administration » Sending query results to file without using SPOOL
Sending query results to file without using SPOOL [message #373256] Fri, 06 April 2001 09:10 Go to next message
Rifki
Messages: 1
Registered: April 2001
Junior Member
Hi,

Does anyone know how to send the output of an SQL query to a text file without using SPOOL in SQL 8i running on Windows NT ?

Thanx

Report message to a moderator

Re: Sending query results to file without using SPOOL [message #373262 is a reply to message #373256] Fri, 06 April 2001 12:45 Go to previous message
Madhav Kasojjala
Messages: 42
Registered: November 2000
Member
The one I know of, through Oracle Front End tools would be using Text_io package and
opening cursor for that SQL to send record by record. If you have server directory access,
you can write a stored procedure to use UTL_FILE package for the same.
HTH
Madhav

Report message to a moderator

Previous Topic: Procedure
Next Topic: Description of Candidate and alternate keys
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 17:37:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.