Home » RDBMS Server » Server Utilities » converting oracle tables data into text format
converting oracle tables data into text format [message #69453] Wed, 09 January 2002 05:44 Go to next message
Shrirang
Messages: 8
Registered: October 2000
Junior Member
hello friends,
is there any utility available with oracle with which i can convert the data in oracle table to text file as we all it in foxpro...
Any help is highly appreaciated.
Thanks in advance.
-bye.
Re: converting oracle tables data into text format [message #69454 is a reply to message #69453] Wed, 09 January 2002 06:31 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
use spool command at sqlprompt and run query.

example:
set heading off
set term off
set line 1000
spool tab1.dat
select * from tab1;
spool off
set term on

save this script in file and run at sqlprompt.
Previous Topic: Re: OCP Exam
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Wed Feb 28 20:07:42 CST 2024