Re: How do I access Oracle 8i tables from a korn shell script

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Dec 2000 07:56:40 +0100
Message-ID: <921j28$5qmjf$2@ID-62141.news.dfncis.de>

Yes you need to invoke sqlplus. Seems rather obvious. The output of sqlplus goes to stdout, so as long as you invoke sqlplus with the -s option you can do something like
sqlplus -s <un>/<pw> @yourscript | ...

Hth,

Sybrand Bakker, Oracle DBA

"toddthom" <orclnwsgrp_at_hotmail.com> wrote in message news:920vb9$7rt$1_at_nnrp1.deja.com...
> I'm a beginner and I'm wondering how to access Oracle 8i using a korn
> shell script. I'd like to issue a SQL select statement on a table in
> our database and somehow import the results back to my script for
> further processing. Is it necessary to invoke SQL+ and
> then pipe the results back to a file?
>
> Thanks
>
> Todd
>
> --
> Peace
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Dec 23 2000 - 00:56:40 CST