Re: passing SQL statements to sqlplus

[Quoted] from unix you can do something like this

sqlplus username/password << eof1
select * from tab;
exit
eof1

This will execute anything between the eof1 on the first line and the eof1 on the last line. Not sure if thats what you want.

Conan

Ray Porter wrote in message <8ls1qk$o1m$1_at_news2.isis.unc.edu>...
>I know how to pass a file containing sql statements to SQLPlus in silent
>mode. Is there a way to pass a single sql statement without putting it in
 a
>file? I'd like to be able to do something like:
>
>sqlplus -s user/passwd 'truncate table myTable'
>
>Is there anyway to do this without putting the truncate (or any other
>statement) in a file?
>
>Thanks,
>================================================
>Ray Porter
>Applications Analyst Programmer
>Administrative Information Services, UNC-CH
>Phone: 966-5878
>email: ray_porter_at_unc.edu
> dragon_at_email.unc.edu
>Home Page: http://www.unc.edu/~dragon/
>
>"Meddle not in the affairs of dragons,
>for thou art crunchy and taste good with ketchup."
>
>
>
Received on Fri Jul 28 2000 - 00:00:00 CEST