OraFAQ Forum: Linux » Shell Script to download Data from a Database table to a Flat file

Home » Infrastructure » Linux » Shell Script to download Data from a Database table to a Flat file (Redhat Linux 5, Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shell Script to download Data from a Database table to a Flat file [message #606758]

Tue, 28 January 2014 22:48

sonudev
Messages: 26
Registered: November 2009
Location: bangalore

Junior Member

How to write a shell script to download data from a database table to a flat file? I am using Redhat Linux and Oracle 10g.
Thanks for any suggestion.

Report message to a moderator

Re: Shell Script to download Data from a Database table to a Flat file [message #606759 is a reply to message #606758]

Tue, 28 January 2014 22:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus scott/tiger
spool emp.txt
select * from emp;
spool off
exit

Report message to a moderator

Re: Shell Script to download Data from a Database table to a Flat file [message #606780 is a reply to message #606758]

Wed, 29 January 2014 05:30

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

sqlplus scott/tiger  << EOI
spool emp.txt
select * from emp;
spool off
EOI

Similar to what Blackswan said. Also, look into the COLSEP system variable depending on how you want the output formatted.

HTH
-g

[edit: formatting]

[Updated on: Wed, 29 January 2014 05:32]

Report message to a moderator

Re: Shell Script to download Data from a Database table to a Flat file [message #607422 is a reply to message #606780]

Thu, 06 February 2014 03:08

sonudev
Messages: 26
Registered: November 2009
Location: bangalore

Junior Member

Thanks BlackSwan and gazzag for giving me hints on this.

Report message to a moderator

Previous Topic:	Oracle 11g on Debian wheezy support
Next Topic:	Oracle 11 g installation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 05 04:51:38 CST 2025