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

Home -> Community -> Usenet -> c.d.o.server -> Re: File Extension in SQL*PLus Script

Re: File Extension in SQL*PLus Script

From: Eric Kimble <ekimble_at_wfl.fha.dot.gov>
Date: Mon, 28 Oct 2002 13:48:02 -0800
Message-ID: <3DBDB092.1ACE20E0@wfl.fha.dot.gov>


Buck,

in SQL*Plus
set escape on

HTH
Eric

Buck Turgidson wrote:

> I am running a SQL*Plus script, which outputs an HTML-Formatted file.
> I can get it to create a .html extension in UNIX, but not NT. Can
> someone tell me what I need to do to effect this?
>
> This is 8.1.7.
>
> COLUMN A1 NOPRINT NEW_VALUE DATO;
> SELECT TO_CHAR(SYSDATE - 1,'MMDDYY') A1 FROM DUAL;
> SPOOL x:&DATO\.html -- Escape works in Unix, but not NT
Received on Mon Oct 28 2002 - 15:48:02 CST

Original text of this message

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