Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best practice to export TV Guide to TXT / CSV files

kdwolfMar 23 2009 — edited Mar 23 2009
Dear All,

I have working TV Guide exporting to XML using Oracle 10g. Now I have a request to allow to export it to a TXT file delemeted by commas or tabs.
Thought using of External Tables will do the work, same as I import the data, but seems that I am wrong - it excepts only ORACLE_DATAPUMP type,
so the file can't be seen in a simple notepad / text editor.

What shall I do? Is there any documents I can read about?

Many thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 20 2009
Added on Mar 23 2009
16 comments
711 views