SQL*Plus: How can I write each record to a separate file

Hi,

I need to select a set of records, and then write each record to a separate file.
Something like this (in pseudo code). The idea is to write the salary of each employee to a separate file with the name of the employee.

FOR rec in select * from emp LOOP
  create file with filename rec.ename
  write rec.sal to file
  close file
END LOOP Is this possible using SQL*Plus? Or would you recommend another tool.

Thanks! Received on Fri Sep 08 2006 - 00:38:10 CDT