Define a variable using a select statement
From: case <k_peeters_at_hotmail.com>
Date: 19 Dec 2003 06:11:47 -0800
Message-ID: <7ae1f085.0312190611.581cd3b6_at_posting.google.com>
[Quoted] 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;
Date: 19 Dec 2003 06:11:47 -0800
Message-ID: <7ae1f085.0312190611.581cd3b6_at_posting.google.com>
[Quoted] 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;
prompt " "
prompt " another weird text "
set term off
spool &&LST-&&DAG
select * from some_table
/
spool off
set term on
set verify on
However it doesn't work. The file is called "some-list-select" What did I do wrong?
TIA, Kees Received on Fri Dec 19 2003 - 15:11:47 CET