Hi,We have to select some rows from a table using many conditions in the where clause. Then we have to write those selected rows to one flat file. I know that we can use UTL_FILE package to do this. Is there any better approach to do this??

  • Interview Candidate
  • 5
  • 2231

Showing Answers 1 - 5 of 5 Answers

sri

  • Sep 30th, 2006
 

    Hi

      we can write those selected rows into file by using spool ;

  Was this answer useful?  Yes

Mohammed Rafeqh

  • Oct 6th, 2006
 

There is no proper response

  Was this answer useful?  Yes

hindol_saha

  • Mar 27th, 2007
 

spool c:filename.txt
select * from tab where ................;
spool off;
goto c: and check it.i think it is the easyest way to store some data from oracle to flat file...u can save it in any extension like .csv.xls.txt ect............

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions