Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLPLUS from a command prompt

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@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 Thu Sep 06 2001 - 15:07:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US