RE: help - spool file name

From: Diego Cutrone <dcutrone_at_afip.gov.ar>
Date: Mon, 23 Apr 2001 13:38:14 -0700
Message-ID: <F001.002EF9EB.20010423132420@fatcity.com>

Hi,

I don't quite understand your question, so here's what I understood:

Just enclose the variable name with "{ }" , here's an example

/home/oracle> export
temp_variable=TEST/home/oracle> echo
"this_is_a_$temp_variable_only"this_is_a_




        -- wrong/home/oracle> echo

"this_is_a_${temp_variable}_only"this_is_a_TEST_only/home/oracle>

Hope it helps
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Helen Zhung

To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L Sent: Monday, April 23, 2001 2:50
PM
Subject: help - spool file name - use variable

   Hello:
  I'm trying to spool out couple of files from my temp table. Part of the   file name is coming from a variable from the temp table. I use:   spool C:\CYCLE_COUNT_$temp_variable.DAT   but it's only one physical name instead of using the variable.   How can I code the variable name as part of (spool) file name?   Thanks

Do You Yahoo!?Yahoo!
Auctions - buy the things you want at great prices Received on Mon Apr 23 2001 - 15:38:14 CDT

RE: help - spool file name - use variable