insert all
when sal>1000 then
into emp values(empid,sal)
when deptno=30 then
into dept values(deptno,loc)
select empid,sal,deptno,loc
insert first
如果第一个when满足条件,则跳过其它when
使用
select id from test1 versions between scn minvalue and maxvalue where name='qi';
查看语句更新字段前后值
select versions_starttime,versions_endtime,id from test1 versions between scn minvalue and maxvalue where name='qi';
可以查看更改版本时间
时区(不知道有什么用,都一般用在那里)
current_time
current_timestamp
localtimestamp
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
alter session set time_zone='-4:00';
select sessiontimezone from dual;
select dbtimezone from dual;
interval
extract
to_offset
from_tz
to_timestamp
to_yminterval
to_dsinterval