Set long 10000000;
spool filename;
select column_name
from table;

This will put the contents of the column into the filename you specify.