Send SQL* Plus session output to text file

How do you send the output of your SQL* Plus session to a text operating system file

shrinidhiks
Profile Answers by shrinidhiks Questions by shrinidhiks
Apr 5th, 2008
2
5891

Showing Answers 1 - 2 of 2 Answers

lanka_satya
Profile Answers by lanka_satya

Jul 4th, 2008

well you want to see the output ina text file............

this can be done by spooling the data;

for example..you want to see the output of the details of all employees:

do the following steps:

spool c:satya.txt
/
select * from emp
/
spool off;

now you can go to c drive there you can the following file and can get the result there