external file

[deulyd]

Is there another way to write to an external file than with the UTL_FILE package?

thanks

 

[THoey]

You could use the SPOOL command and then do a SQL statement.

SPOOL MyFile.txt

SELECT *
FROM MyTable;

SPOOL OFF

If you wantted to make it comma delimeted, select your specific fields and concatenate using the pipes (||). Terry M. Hoey

 

[carp]

SPOOL will only work from SQL*Plus. If you want to write to a file from within a PL/SQL program, I think UTL_FILE is about as good as it gets.