Re: SQLPLUS from a command prompt
From: Jon Schlatter <*jon-schlattter_at_stamats.com>
Date: Thu, 6 Sep 2001 21:15:18 -0500
Message-ID: <tpgb79o3s27p01_at_corp.supernews.com>
Date: Thu, 6 Sep 2001 21:15:18 -0500
Message-ID: <tpgb79o3s27p01_at_corp.supernews.com>
Please disregard this posting. I figured it out.
Thanks
Jon
"Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message
news:tpfld1ri1qj78f_at_corp.supernews.com...
> I am trying to get a batched SQL PLUS command to work. It is supposed to
> output to an HTML files that will reside on the web server. I have read
> about the markup command, but cannot get it to work. Can anyone help? Here
> is what I have now.
>
> SET ORACLE_SID=databasename
> sqlplus -MARKUP "HTML ON PRE ON" SPOOL
> C:\INETPUB\WWWROOT\JOBSTATUSREPORT.HTM acct/password_at_database @c:\g.sql
>
> TIA
> JON
>
>
Received on Fri Sep 07 2001 - 04:15:18 CEST