Exporting into text file

[draganp]

Hi,<br><br>I'm trying to export the result of my SELECT<br>statement into .txt file. Can anybody gave any hint how to do that ?<br><br>Thanks

 

[ViViD]

declare a file variable:<br>&nbsp;&nbsp;out_file&nbsp;&nbsp;TEXT_IO.FILE_TYPE;<br>...<br>open it:<br>out_file := TEXT_IO.FOPEN('C:\TEMP\FOO.TXT','W');&nbsp;&nbsp;(or 'A' to append)<br><br>do your select into var1, var2...<br>create a text string:<br>text := var1 ¦¦ var2 ¦¦&nbsp;&nbsp;(use delimiters if you need: ¦¦ ',' ¦¦<br><br>write to it:<br>&nbsp;&nbsp;TEXT_IO.PUT_LINE(out_file,text);<br>&nbsp;&nbsp;TEXT_IO.NEW_LINE;<br><br>close it:<br>&nbsp;&nbsp;TEXT_IO.FCLOSE(out_file);

 

[draganp]

I found out that it is also possible to do that from utl_file package using the same functions.<br><br>Thank you !!!