Oracle sqlplus query output into file

Hello,

How can I put an Oracle sqlplus query output into file?

SQL> select myfield from userDB where IMSI like '22803%' and rownum < 11;

I would like to put the output in a file, say '/tmp/mydata.dat'

Thanks for your help.

phil

you can use the SPOOL command to save the output into file and send it directly to the printer, for file follow the instruction:

SQL>SPOOL /tmp/mydata.dat

SQL>select myfield from userDB where IMSI like '22803%' and rownum < 11;

SQL>SPOOL OFF

now go to specified location and open the file, if you find anything garbage , remove it.