Re: Q: Execute SQL from command line?
From: <bhattpranav_at_my-deja.com>
Date: Fri, 23 Jul 1999 19:17:47 GMT
Message-ID: <7naf4j$t6e$1_at_nnrp1.deja.com>
Date: Fri, 23 Jul 1999 19:17:47 GMT
Message-ID: <7naf4j$t6e$1_at_nnrp1.deja.com>
Hi Lu
you will have to set spool on by giving a filename and then execute SQL
command and when you are done with it set spool off.
pranav
> 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!
>
> - Lu
>
>
Sent via Deja.com http://www.deja.com/
[Quoted] Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 21:17:47 CEST