GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  D2K
Go To First  |  Previous Question  |  Next Question 
 D2K  |  Question 37 of 71    Print  
How to store the form data in Excel sheet in form 6i?

  
Total Answers and Comments: 3 Last Update: February 06, 2007     Asked by: kvvsrinivas 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: summa
 
Using Text_IO package the form data will store in Excel sheet

Above answer was rated as good by the following members:
saini006
November 07, 2006 09:27:00   #1  
anil        

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;


 
Is this answer useful? Yes | No
November 07, 2006 09:47:41   #2  
anilpj2 Member Since: November 2006   Contribution: 1    

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

by using TEXT_IO package

for example:

decalre


 
Is this answer useful? Yes | No
February 06, 2007 04:55:03   #3  
summa        

RE: How to store the form data in Excel sheet in form...
Using Text_IO package the form data will store in Excel sheet
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape