GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  D2K

 Print  |  
Question:  How to store the form data in Excel sheet in form 6i?



November 11, 2006 09:27:00 #1
 anil   Member Since: Visitor    Total Comments: N/A 

RE: How to store the form data in Excel sheet in form...
 

yes by using  "Text_io" package

for example:

declare
 x text_io.file_type;
begin
 x:=Text_IO.Fopen('c:bonus.csv', 'w');                                                     for rec in(select * from emp) loop
 Text_io.put_line(x,rec.period_name||','||rec.col1||','||rec.col2||','||rec.col3);
 end loop;
 Text_IO.Fclose(x);
end;

     

 

Back To Question