sql 多表插入和时区

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