passing SQL statements to sqlplus

From: Ray Porter <ray_porter_at_unc.edu>
Date: 2000/07/28
Message-ID: <8ls1qk$o1m$1_at_news2.isis.unc.edu>#1/1

[Quoted] 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 [Quoted] file? I'd like to be able to do something like:

[Quoted] 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