Re: Can I query from command line?

From: Jerry Gitomer <jgitomer_at_ictgroup.com>
Date: Tue, 15 Sep 1998 18:24:14 GMT
Message-ID: <ihyL1.61$6T6.116607@client.news.psi.net>

Hi Mike,

Use you favorite editor to write up a query and then (assuming you named is query.sql)

$> sqlplus <user>/<password> @query

regards

Jerry

Mike Wright wrote in 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 Tue Sep 15 1998 - 13:24:14 CDT