Extract data to text using 8i pl-sql
Posted on 2006-04-24
I have worked in oracle 9i but 8i is new to me. I need to extract some data which i assume is in the record cursor to a text file output.
I have never extracted data to a text file using pl-sql. Some of the things I want to do in the pl-sql procedure for above task is e.g.
1)hardcode file name for every new text file created by this procedure ...
e.g. 'File name ABC/ref10029'
2) how to move to new line in the text file. e.g. first line would have file name , second would have record for employee and third line would have order details and something like that. My question is how to move to a new line while extracting data to a text file using oracle 8i pl-sql.
Thats for now.
Thanks for your help/code sample.