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
Go To First  |  Previous Question  |  Next Question 
 D2K  |  Question 37 of 68    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  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape