sqlplus -s userid/password <<EOD >file.log
set head off termout off lines 0
select ....
...
EOD
Hpoe this help.
Mike Wright a écrit dans le message <6tlo0m$gbs$1_at_sally.dma.org>...
>Is it possible for me to write a shell script to query my
>Oracle db? We have fancy GUI query tools but there are many
>times that it is overkill for my simple needs. I already know
>the basics of writing a SQL query, but need some help with
>the simple mechanics of logging in and connecting with the
>db. I'm using Solaris.
>
>--
>Mike Wright
Received on Wed Sep 16 1998 - 01:39:42 CDT
