Writing Text File From A Tabular Block In Oracle Forms

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了Writing Text File From A Tabular Block In Oracle Forms，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1170字，纯文字阅读大概需要2分钟。

内容图文

The example given below for writing text file or  CSV  using  Text_IO  package from a tabular block in Oracle Forms.

 

Suppose there is a tabular grid data block "Job_History" in your forms and you want to write a CSV on click of a button by reading whole block from top to bottom. The following is the demo screen shot:

 

 

You can also download this form from this link Job_History_Csv.fmb .

 

Write the following  When-Button-Pressed  trigger code for the "Export To CSV" button:

 

Declare

out_file text_io.file_type;

v_line varchar2(1000);

begin

out_file := text_io.fopen(‘C:\job_history.csv‘, ‘w‘);

go_block(‘job_history‘);

-- move control to first record;

first_record;

loop

 v_line := :job_history.employee_id||‘,‘|| :job_history.start_date||‘,‘|| :job_history.end_date ||‘,‘||

           :job_history.job_id||‘,‘|| :job_history.department_id;

 text_io.put_line(out_file, v_line);

 -- move control to next record;

 if :system.last_record = ‘TRUE‘ then

     exit;

 end if;

 next_record;

end loop;

text_io.fclose(out_file);

-- again after completion move control to first record

first_record;

end;

 

原文：http://www.cnblogs.com/quanweiru/p/6220334.html

内容总结

以上是互联网集市为您收集整理的Writing Text File From A Tabular Block In Oracle Forms全部内容，希望文章能够帮你解决Writing Text File From A Tabular Block In Oracle Forms所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---