Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to export data from query to flat ascii file

Re: How to export data from query to flat ascii file

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 15 Jun 2005 08:09:10 -0700
Message-ID: <1118848150.004937.205850@g14g2000cwa.googlegroups.com>

And here is an article with the code to just perform the task using SQLPlus:

How do I export a database table to a flat file ?

http://www.jlcomp.demon.co.uk/faq/flatfile.html

HTH -- Mark D Powell -- Received on Wed Jun 15 2005 - 10:09:10 CDT

This message: [ Message body ]
Next message: thtsang_yh_at_yahoo.com.hk: "Re: ORA-22288 when DBMS_LOB.FILEOPEN even if server can see the file"
Previous message: Vince Laurent: "Re: Increase SAP/Oracle Table GLSP___0"
In reply to: sybrandb_at_yahoo.com: "Re: How to export data from query to flat ascii file"
Next in thread: joel-garry_at_home.com: "Re: How to export data from query to flat ascii file"
Reply: joel-garry_at_home.com: "Re: How to export data from query to flat ascii file"
Reply: Tomislav Kokoska: "Re: How to export data from query to flat ascii file"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US