RE: help - spool file name - use variable

2001-04-24 Thread Gogala, Mladen
How about spool report_id.dat ? -Original Message- Sent: Monday, April 23, 2001 6:22 PM To: Multiple recipients of list ORACLE-L I'm writing a sql script file (first run couple of queries, insert results into a temp table), at last, the data need to spool out to separate files. the

RE: help - spool file name - use variable

2001-04-24 Thread Helen Zhung
I tried, but didnot work. I hard code them now. Thanks "Gogala, Mladen" [EMAIL PROTECTED] wrote: How about "spool report_id.dat" ?-Original Message-Sent: Monday, April 23, 2001 6:22 PMTo: Multiple recipients of list ORACLE-LI'm writing a sql script file (first run couple of queries,

RE: help - spool file name - use variable

2001-04-24 Thread Gogala, Mladen
What exactly didn't work? Do you have define on or off? -Original Message- Sent: Tuesday, April 24, 2001 2:53 PM To: Multiple recipients of list ORACLE-L I tried, but didnot work. I hard code them now. Thanks Gogala, Mladen [EMAIL PROTECTED] wrote: How about spool

RE: help - spool file name - use variable

2001-04-23 Thread Diego Cutrone
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