01，日期格式化输出
SQL> alter session set NLS_DATE_FORMAT='YYYY-MM-DD HH24:mi:ss';
SQL> select sysdate from dual;
SYSDATE
-------------------
2019-06-21 14:26:08
SQL> alter session set nls_date_
把查询内容输出到文本
set echo off pagesize 0 heading off feedback off termout off
spool test.sql
select count(*) from user_tables;
spool off
上面的脚本执行完之后就会将查询内容输出至test.sql
第一行中的set命令对环境进行了设置
具体要设置哪些可以根据需求自
select * from ( select 'Nick' as item from dual union all select 'Viki' as item from dual union all select 'Glen' as item from dual union all select 'Robin' as item from dual u
