Re: Can I query from command line?

From: <mpir_at_compuserve.com>
Date: Wed, 16 Sep 1998 18:16:39 GMT
Message-ID: <6tova7$grc$1@nnrp1.dejanews.com>

In article <6tlo0m$gbs$1_at_sally.dma.org>, wrightm_at_dmapub.dma.org (Mike Wright) wrote:
> 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
>

the command would be

sqlplus youruserid/yourpassword @yoursqlplusscript

'yoursqlplusscrpt' is the file that contains the sql commands to be run. (be sure it ends with an exit) THe file should show up in a directory listing as

yoursqlplusscript.sql

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 16 1998 - 13:16:39 CDT