Re: How to extract table contents to files?

quite simple really!

Just place your select statement in a sql script then redirect the output to a file.

eg:
A file name fred.sql contains:-

   SELECT * from SALES;

% sqlplus -s fred.sql >fred.out

fred.out will contain what you want. Received on Tue Jan 03 1995 - 19:19:24 CET