col v_filename new_value v_filename noprint
Select to_char(sysdate,'yyyymmdd')||'.txt' v_filename from dual;
spool e:&v_filename;
select * from dual;
spool off;
sqlplus中利用spool生成带日期的文件名
最新推荐文章于 2021-04-05 06:59:08 发布
col v_filename new_value v_filename noprint
Select to_char(sysdate,'yyyymmdd')||'.txt' v_filename from dual;
spool e:&v_filename;
select * from dual;
spool off;