Outputting to a file If you want to want to extract data easily to a file sqlplus the command line utility from Oracle can come quite handy. > SPOOL filename > SPOOL OFF References StackOverflow