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-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, i

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-23 Thread Helen Zhung
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 requirement was want the report name to be able to change depend on the query. Therefore, I have a variable in the temp table. Now I want to be

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_