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??
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............
RE: 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??
yOU CAN USE TEXT_IO.PUTLINE INBUILTS
OR YOU CAN USE THE SPOOL FUNCTION BOTH ARE APPLICABLE
