Re: How to convert Oracle tables/views etc to text files

You can use sqlplus with commands
spool table.txt;
select * from table;
spool off;
and you have table in txt fromat.

pgaur_at_cdotd.ernet.in wrote:

> Hi , There is a strong need for this aspect here and I don't know how to
> do it. Is there some way to convert the Oracle Table/views etc in Text files,
> so that these text files can be used by some other program. I am not very
> much familiar with Oracle programming as I am now these days only reading the
> manual of Oracle, till now I was not able to find any such possibility.
> Thanks in advance !!!!! Praveen Gaur
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Received on Thu Jan 07 1999 - 07:13:07 CST