Generating SQL Output files
576644Nov 12 2009 — edited Nov 16 2009Hi,
I have got 5 tables in my schema and I want to generate output files using data from all these tables to an output file through a stored procedure.
I do not want to use UTL_FILE package to do this. We are using UNIX operating system and files should directly be stored into these fixed folders.
I thought about using SPOOL utility, it stores all the SQL command output in the given file, but
it stores the output file under SQL*Plus bin folder in the local work station.
Please share your ideas and suggestions to get the best method available for this requirement, thank you.