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

<zrwcvhsosoik001_at_sneakemail.com> a écrit dans le message de news: 1157693890.455984.274350_at_e3g2000cwe.googlegroups.com...
| 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!
|

I posted a solution for this kind of issue on AskTom. Have a look at:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:127412348064#61079610047885

Regards
Michel Cadot Received on Fri Sep 08 2006 - 10:20:33 CDT