SQLPLUS from a command prompt
From: Jon Schlatter <*jon-schlatter_at_stamats.com>
Date: Thu, 6 Sep 2001 15:07:49 -0500
Message-ID: <tpfld1ri1qj78f_at_corp.supernews.com>
[Quoted] 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.
Date: Thu, 6 Sep 2001 15:07:49 -0500
Message-ID: <tpfld1ri1qj78f_at_corp.supernews.com>
[Quoted] 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 Thu Sep 06 2001 - 22:07:49 CEST