Re: Q: Execute SQL from command line?

On Thu, 22 Jul 1999 05:47:08 GMT, Lu Gan <lugan_at_esumer.com> wrote:
>Hi,
>
>Is there a simple way to execute a SQL statement against an Oracle
>database from the command line and have the result output to stdout or
>to a file? I am expecting something like:
>
>$ sqlplus2 connect-string -e "sql-statement" > /tmp/file.1
>
>Any help will be greatly appreciated!

        echo "statement ;" | sqlplus user/pass_at_tname > outfile

-- 

It helps the car, in terms of end user complexity and engineering,         
that a car is not expected to suddenly become wood chipper at some    |||
arbitrary point as it's rolling down the road.                       / | \
						                       
			Seeking sane PPP Docs? Try http://penguin.lvcm.com