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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Re: OCP Exam
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:18:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.