- column today new_value today_file
- select (select utl_inaddr.get_host_address from dual)||'_'||instance_name||'_'||to_char(sysdate,'yyyymmddhh24miss') as today from v$instance;
- spool get_priv_&&today_file..txt
- select 1 from dual;
- spool off
结果如下:
get_priv_192.168.1.8_orcl_20120611120826.txt
阅读(7162) | 评论(0) | 转发(0) |