--创建全局临时表
declare v_CreateTemp varchar2(2000);
v_CreateTemp:='CREATE GLOBAL TEMPORARY TABLE TEMP_TB as
select * from DataTB where rownum=0;';
EXECUTE IMMEDIATE v_CreateTemp;
--将A.ID=B.ID的B表中几个字段更新到A表中
UPDATE TestAA A
SET (A.TestName,A.A01,A.A02) =
(SELECT B.TestName,B.A01,B.A02
FROM TestTB B WHERE A.id=B.id
) where A.ID in(SELECT D.ID FROM TestTB D);
--取相同记录中最新的记录
select A.* from A where not exists(
select 1 from B where A.id=B.id and A.tlastupdatedate<B.tlastupdatedate);
--查询两日期相关的月份数
select months_between(date'2014-04-23',date'2013-04-22') from dual