how to convert oracle data into txt file?

Answer 1

You can use an SQL*PLUS script that selects while you are spooling to a file. You just have to

spool path/filename
SELECT
spool off

There are lots of options that are available doing this, like creating a comma delimited file, a fixed length file and so on.

Answer 2

Import the data in to MS Access, then export it as a text file.

Answer 3

if you are not up to scripting some SQL to do the dirty work, try this, and see if it workd for you..

http://www.nxtract.co.uk/


Hope that helps.