Re: Define a variable using a select statement

k_peeters_at_hotmail.com (case) writes:

> Say, I have to make a daily file which is named "some-list-<number of
> this day>" and want to use this sql-script.
>
> ---------
> set verify off
> set feedback off
> define LST ="some-list"
> define DAG = select to_number(sysdate, 'D') from dual;
...
> spool &&LST-&&DAG

You can use the new_value attribute of the column keyword. Here is an example:

,----

| column nv new_value nv noprint;
| 
| select to_char(sysdate) || '.lis' nv from dual;
| 
| spool &nv
| 
| select * from dual;
| 
| spool off

Harald Received on Fri Dec 19 2003 - 15:48:55 CET